Matched and Not Matched with duplicates



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

Matched and Not Matched with duplicates

Postby 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 ?
gyt3
 
Posts: 16
Joined: Sun Dec 16, 2012 9:58 am
Has thanked: 3 times
Been thanked: 0 time

Re: Matched and Not Matched with duplicates

Postby 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.
//DETERMIN EXEC PGM=SORT
//SYSOUT   DD SYSOUT=*
//SORTIN DD *
RECORD
/*
//SORTOUT DD DUMMY
//SYSIN   DD   *
  OPTION COPY
/*
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Matched and Not Matched with duplicates

Postby gyt3 » Sun Dec 16, 2012 10:08 pm

Can u make it little more clear
gyt3
 
Posts: 16
Joined: Sun Dec 16, 2012 9:58 am
Has thanked: 3 times
Been thanked: 0 time

Re: Matched and Not Matched with duplicates

Postby 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.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Matched and Not Matched with duplicates

Postby 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.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: Matched and Not Matched with duplicates

Postby 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).
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post