Dear All,
Please find my requirement
InFile1
--------
length - 1045
REFM - VB
Key Field - 1 to 9
No duplicate records
Data looks like
============
111111111 aaaaaa bbbbbbbb
222222222 bbbbbb cccccccc
333333333 ccccccc aaaaaaaa
444444444 ccccccc aaaaaaaa
InFile2
--------
length - 1045
REFM - VB
Key Field - 1 to 9
No duplicate records
Data looks like
=============
111111111 aaaaaa bbbbbbbb
222222222 bbbbbb cccccccc
444444444 ccccccc aaaaaaaa
Outfile requirement
-------------------------
I want only key fields 9 bytes in the output record, not required any other fields of the matching records.
length - 80
REFM - FB
111111111
222222222
444444444
My workshop using SYNCSORT, Messages appearing as WER#### in spool from that I am saying we use SYNCSORT. Could You please help me on SORT card for this.
Thanks..!
SORT FIELDS = COPY
JOINKEYS FILES=FILE1,FIELDS=(5,13,A)
JOINKEYS FILES=FILE2,FIELDS=(5,13,A)
JOIN UNPAIRED,F1,F2,ONLY --> Hope this will pick the unmatched records, I need to change this to select the only matched records.