Page 1 of 1
Matched and Not Matched with duplicates
Posted:
Sun Dec 16, 2012 7:26 pmby gyt3
I want to compare two files say File 1 and File 2 and take the matched records seperately in Outfile 1 and Not matched records in Outfile 2.
The key field of file 1 is (01,15,A) and file 2 is (20,15,A)
Both input files contains duplicates.Duplicates should not be eliminated in the output.
Can someone help me how to get the required output using ICETOOL / SORT ?
Re: Matched and Not Matched with duplicates
Posted:
Sun Dec 16, 2012 9:15 pmby BillyBoyo
Which Sort product are you using? And what level is the product at?
Please run this, and post the sysout from it here, in the Code tags.
//DETERMIN EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD *
RECORD
/*
//SORTOUT DD DUMMY
//SYSIN DD *
OPTION COPY
/*
Re: Matched and Not Matched with duplicates
Posted:
Sun Dec 16, 2012 10:08 pmby gyt3
Can u make it little more clear
Re: Matched and Not Matched with duplicates
Posted:
Sun Dec 16, 2012 10:35 pmby BillyBoyo
We need to know which Sort product you use. If you run what I have provided, and post the sysout, then we will know.
Re: Matched and Not Matched with duplicates
Posted:
Tue Dec 18, 2012 3:53 amby NicC
And once you have shown us which sort product you use we can move the topic from JCL to the correct sort section. Also, have you tried searching (of course you have as it is a pre-requisite to posting)? You probably need joinkeys.
Re: Matched and Not Matched with duplicates
Posted:
Wed Dec 19, 2012 3:18 amby dick scherrer
Hello,
Can u make it little more clear
Not until you submit the requested job ad post the output (using the Code tag).