IBM Mainframe Forum

How to convert an FB file to VB

I have 2 i/p files which are in VB
I have to compare these two files for a perticular field and if match occures , I have to write to o/p file .
I have tried using SORT join with reformat fields bt am unable to create the o/p file in VB.



I have used the below SORT join keys syntax

JOINKEYS FILES=F1,FIELDS=(9,4,A)
JOINKEYS FILES=F2,FIELDS=(21,4,A)
REFORMAT FIELDS=(F2:5,16,F1:9,4,F2:25,4072)
SORT FIELDS=COPY

As the i/p files are in VB I have added 4 bytes .

Bt when am using the above sysntax am unable to give the VB o/p file format ....
How can indicate the o/p file as VB in Reformat fields?

Which Sort product are you using (DFSORT? Syncsort?).

I t is simple DFSORT

How can indicate the o/p file as VB in Reformat fields?

By specifying the RDW and a starting position without a length. For example:

Thank u for ur solution bt if am mentioning the o/p file RECFM as VB it is giving an error

Thank u for ur solution bt if am mentioning the o/p file RECFM as VB it is giving an error

I don't know if you used my REFORMAT statement, your incorrect REFORMAT statement or some other REFORMAT statement.
I don't know what error you're getting.

You need to show the job you're using and the messages you received before I can help you.

Also, tell me the RECFM and LRECL of the input file and expected output file.