Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Converting VB File to FB

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
poka

New User


Joined: 07 Aug 2008
Posts: 2
Location: albany

PostPosted: Wed Aug 13, 2008 1:35 am    Post subject: Converting VB File to FB
Reply with quote

Hi.

I have a I/P & O/P VB File and the length of the file is 10504 in JCL including 4 bytes.

Each record in this file is of different length and i don't know the actual length's for each record.

Say record 1 is 100 bytes and then remaining 10400 bytes is having Nulls.
Say record 2 is 2000 bytes and then remaining 8500 bytes is having Nulls.
Say record 3 is 2000 bytes and then remaining 8500 bytes is having Nulls.

My problem is to convert only Trailing Nulls to Spaces.

I would appreciate if anyone responds to this posting.

Thanks,
Srini
Back to top
View user's profile Send private message

CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Wed Aug 13, 2008 1:57 am    Post subject:
Reply with quote

What sort product do you have?
What programming languages do you have?
Can you use REXX?

In your example, are you trying to convert the 100 byte VB record and the two 2000 byte VB records to a FB format with a lrecl of 10504 bytes with spaces for padding?
Back to top
View user's profile Send private message
poka

New User


Joined: 07 Aug 2008
Posts: 2
Location: albany

PostPosted: Wed Aug 13, 2008 2:05 am    Post subject: Reply to: Converting VB File to FB
Reply with quote

we use sort,syncsort,icetool in our shop and rexxtool is not allowed.

i am converting VB to VB same length.
When i did conversion , i got nulls as Trailing character's for every record after the actual length of each record .

Each record length varies based on data present in each record.

Thanks
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10231
Location: italy

PostPosted: Wed Aug 13, 2008 2:20 am    Post subject: Reply to: Converting VB File to FB
Reply with quote

Quote:

i am converting VB to VB same length.


VB to VB conversion is a kind of useless process

Using VB records is a way of saving dasd space by wring to dasd only the data available and needed

do You realize that when converting VB to FB You might waste a tremendous amount of space

for example 1 track will hold approximately 540 100bytes records
if You convert these record to a fixed format with a record length of 10550
only 4 records will fit on a track and the space used to hold the 540 records will be 135 tracks r 9 cylinders..... meditate
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Wed Aug 13, 2008 2:33 am    Post subject: Re: Reply to: Converting VB File to FB
Reply with quote

poka wrote:
When i did conversion , i got nulls as Trailing character's for every record after the actual length of each record .
When you displayed the record you saw trailing nulls to the max lrecl of 10504?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Aug 13, 2008 3:01 am    Post subject:
Reply with quote

Hello,

How do you define "nulls"?

There is no NULL Value concept in a qsam file - whether it is fixed or variable length. . .
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Wed Aug 13, 2008 11:27 am    Post subject:
Reply with quote

And if you EDIT the file - YES you will see blanks X'40' right up until the end of the record length.
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Wed Aug 13, 2008 12:20 pm    Post subject:
Reply with quote

Hi,

and if you browse the file and put HEX ON you will see where the data ends.


Gerry
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Changing of LRECL of a file abdulrafi DFSORT/ICETOOL 1 Fri Mar 24, 2017 3:25 pm
No new posts splitting a file abdulrafi DFSORT/ICETOOL 3 Fri Mar 24, 2017 11:51 am
No new posts Receive a file using PCOMM macro Harald.v.K IBM Tools 0 Thu Mar 23, 2017 6:50 pm
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Formatting VB File Learncoholic DFSORT/ICETOOL 3 Mon Mar 20, 2017 12:29 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us