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



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

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

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

Re: 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

Postby 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..

//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 :-

0001952000000000100000008
0012121000000011100000121
Thanks
-3nadh
User avatar
bodatrinadh
 
Posts: 67
Joined: Thu Jan 12, 2012 9:05 pm
Has thanked: 0 time
Been thanked: 4 times

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

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

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

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

Previous

Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post