IBM Mainframe Forum

by **BillyBoyo** » Mon Sep 17, 2012 4:11 pm

Just had a thought. In their second post, Puneet (finally) explained that the data can be in any order, so obviously does need the SORT anyway.

The interesting thing is then, how to get the MINimum beginning range if it is not on the first record? Does it work coding the MIN for 6,10?

I assume you are defaulting to OPTION EQUALS at your site for it to work in your test with the data from Puneet's first?

by **bodatrinadh** » Tue Sep 18, 2012 9:49 am

Hi Billy, Sorry for the delay...

Even in SYNCSORT, it is mandatory to use SORTIN01 for Merge..
Here is with MIN option..

Select all

//SYSPRINT DD SYSOUT=*
//SORTIN01 DD *
0001952000000000100000008
0001952000000001000000020
0001952000000003000000040
0012121000000011100000121
0012121000000015100000191
//SORTOUT DD SYSOUT=*
//SYSIN DD *
OPTION EQUALS
MERGE FIELDS=(1,5,CH,A)
DUPKEYS MIN=(6,10,ZD)

Output :-

Select all

0001952000000000100000008
0012121000000011100000121

by **NicC** » Tue Sep 18, 2012 12:31 pm

This is a duplicate of a post on anothter forum. I cannot do anything over there but I can stop this one.

by **BillyBoyo** » Tue Sep 18, 2012 1:45 pm

To be fair Nic, the other one was from several days before this. It has also appeared in a couple (at least) of LinkedIn groups.

It is only finally here that we got the full story about the data (can be in any order) and anyone looking at it who actually has SyncSort (bodatrinadh). Whether we ever hear from Puneet again, I don't know :-)

IBM Mainframe Forum

How to Split the record in two part and remove the duplicate

Re: How to Split the record in two part and remove the dupli

Re: How to Split the record in two part and remove the dupli

Re: How to Split the record in two part and remove the dupli

Re: How to Split the record in two part and remove the dupli