mainframegurukul.com

Hi Frank, The RECFM and LRECL of the file with header and trailer will be same as the detail file i.e VB file, LRECL=215 I want the header from file1 detail from file 2 (It is already in sorted order, so no need to sort again) And trailer from file1 and updated The header record is identified by the...

Hi, I have 2 files, the first containing the header and trailer and the second file containing the detail records only. My requirement is to add the header and trailer along with the detail file and also update the trailer count. Can we achieve this in one step? Please help :( Header :: 000000000000...

Hi,

I could do it.

//SYSIN DD *
JOINKEYS FILES=F1,FIELDS=(5,7,A)
JOINKEYS FILES=F2,FIELDS=(5,7,A)
REFORMAT FIELDS=(F1:1,58,F2:13)
OPTION COPY
/*

Thanks

Hi Frank,

Thanks for thr response.
I want the output file also in VB.
How could I do that?

Hi , My requirement is to join two files based on a key. I am using the following job //JK1 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTJNF1 DD DSN=File 1,DISP=SHR //SORTJNF2 DD DSN=File 2,DISP=SHR //SORTOUT DD DSN=File 3, // DISP=(NEW,CATLG,DELETE) // //* //SYSIN DD * JOINKEYS FILES=F1,FIELDS=(1,7,A) ...