Converting from VB to FB format

i413678 · Posted: Wed Mar 08, 2006 7:18 pm

Hi,

We know that to conver VB file to a FB file we use the option CONVERT in control card........I need a clarification on this.

if my input record lengths are like below.
120
300
200
150

and I am converting this VB file to a FB file of record length 300...

Now my doubt is if we convert the VB file to FB file what will be padded if the record length is less then the record length of FB file......

say.......

1. for first record what will be inserted for rest 180 bytes as the record length is only 180
2. no need
3. what will be inserted for rest 100 bytes as the record length is only 200
4. what will be inserted for rest 150 bytes as the record length is only 150

I hope you understood the question.................

Please let me know.........

thx in advance....

pavan

superk · Posted: Wed Mar 08, 2006 7:53 pm

You have the option of using the VLFILL= parameter. Normally, you can use VLFILL=X'40' to fill the fields with blanks (hex '40'). Since VLFILL=X'40' is the default, you can omit it. Otherwise, you can choose any other hex value of your choice.

Frank Yaeger · Posted: Wed Mar 08, 2006 9:58 pm

Note that you can use VLFILL=byte where byte can be any one-byte character constant (e.g. C'*') or any one-byte hex constant (e.g. X'00').
C' ' (X'40') is the default if you don't specify VLFILL=byte.

For more information on DFSORT's VTOF and VLFILL parameters, see:

www.ibm.com/servers/storage/support/software/sort/mvs/tricks/srtmst01.html#t11

i413678 · Posted: Thu Mar 09, 2006 9:56 am

Hi all,

Thank you...................

pavan