icetool for finding matching records from two files

[4ubobby]

Hi,

I want a icetool jcl which can find matching records from two files and write them into a third file.


Here is the layout of both the files

input file 1 lrecl = 168
*******************
the key field starts from 9 position and it is 19 bytes long .

input file 2 lrecl = 80
******************
the key field starts from 1 position and it is 19 bytes long.

input file 1 can have duplicates, however if both the file have the same key i want it to be written to the output file once.

[Frank Yaeger]

See the "Create files with matching and non-matching records" Smart DFSORT Trick at:

http://www.ibm.com/support/docview.wss? ... g3T7000094

If you need more specific help, show an example of the records in each input file (relevant fields only) and what you expect for output. Explain the "rules" for getting from input to output. Give the starting position, length and format of each relevant field. Give the RECFM and LRECL of the input files. If file1 can have duplicates within it, show that in your example. If file2 can have duplicates within it, show that in your example.

Also, run this job and show the //SYSOUT messages you receive, so I can see what level you're at:

Code: Select all

//S1    EXEC  PGM=SORT
//SYSOUT    DD  SYSOUT=*
//SORTIN DD *
RECORD
//SORTOUT DD DUMMY
//SYSIN    DD    *
    OPTION COPY
/*