IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Converting VB File to FB


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
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
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: 2146
Location: At my coffee table

PostPosted: Wed Aug 13, 2008 1:57 am
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
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

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Wed Aug 13, 2008 2:20 am
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: 2146
Location: At my coffee table

PostPosted: Wed Aug 13, 2008 2:33 am
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

Moderator Emeritus


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

PostPosted: Wed Aug 13, 2008 3:01 am
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: 8797
Location: Welsh Wales

PostPosted: Wed Aug 13, 2008 11:27 am
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: 1702
Location: Australia

PostPosted: Wed Aug 13, 2008 12:20 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 1
No new posts Issues Converting From ZD to Signed N... DFSORT/ICETOOL 4
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
Search our Forums:

Back to Top