How to split a file into two file and remove dups?



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

Re: How to split a file into two file and remove dups?

Postby BillyBoyo » Fri Oct 26, 2012 11:43 pm

On your OUTREC you are specifying 9 bytes, you are ending your records with a blank.

I don't know why you'd have 11 byte records, unless perhaps you have an LRECL specified on the DD statement for OUT.

You don't need to specify the "columns", the numbers prior to the ":". All your data follows on from the previous. Putting the columns makes it harder to change later.

Personally, I change OUTREC to BUILD. BUILD exists for INREC, OUTREC and OUTFIL. OUTREC and BUILD are identical.

                  BUILD=(1,2,                 
                         09,03,             
                         09,03)
 


Should get you an eight-byte record-length, unless you have the LRECL in the JCL. Leave off the whole DCB, Sort will provide it.

These users thanked the author BillyBoyo for the post:
mainframegeek (Sat Oct 27, 2012 6:05 pm)
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: How to split a file into two file and remove dups?

Postby mainframegeek » Sat Oct 27, 2012 4:52 pm

Thanks Billy for correcting me. Its working perfectly :) .
mainframegeek
 
Posts: 35
Joined: Sun Sep 16, 2012 1:57 pm
Has thanked: 3 times
Been thanked: 0 time

Re: How to split a file into two file and remove dups?

Postby BillyBoyo » Sat Oct 27, 2012 5:04 pm

No problem. Looking now, shouldn't the first 09,03 be 06,03?

These users thanked the author BillyBoyo for the post:
mainframegeek (Sat Oct 27, 2012 6:05 pm)
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: How to split a file into two file and remove dups?

Postby mainframegeek » Sat Oct 27, 2012 6:09 pm

We need to have three bytes from 9th byte. 3,6 is Min-Nmbr, 6,3 is Max-nmbr and 9,3 is the nmbr from file-2. So only 9,3 is required after key field.
mainframegeek
 
Posts: 35
Joined: Sun Sep 16, 2012 1:57 pm
Has thanked: 3 times
Been thanked: 0 time

Previous

Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post