IBM Mainframe Forum

by **gyt3** » Sun Dec 16, 2012 7:26 pm

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 ?

by **BillyBoyo** » Sun Dec 16, 2012 9:15 pm

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.

Select all

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

by **gyt3** » Sun Dec 16, 2012 10:08 pm

Can u make it little more clear

by **BillyBoyo** » Sun Dec 16, 2012 10:35 pm

We need to know which Sort product you use. If you run what I have provided, and post the sysout, then we will know.

by **NicC** » Tue Dec 18, 2012 3:53 am

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.

by **dick scherrer** » Wed Dec 19, 2012 3:18 am

Hello,

Can u make it little more clear

Not until you submit the requested job ad post the output (using the Code tag).

IBM Mainframe Forum

Matched and Not Matched with duplicates

Matched and Not Matched with duplicates

Re: Matched and Not Matched with duplicates

Re: Matched and Not Matched with duplicates

Re: Matched and Not Matched with duplicates

Re: Matched and Not Matched with duplicates

Re: Matched and Not Matched with duplicates