moving of matched and unmatched records

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

Re: moving of matched and unmatched records

Postby dick scherrer » Tue Sep 11, 2012 7:31 pm

Hello and welcome to the forum,

As your question directly relates to this question, i'll leave it here. Once you become more familiar with how the forum works, you will learn that it is best to start a new topic rather than reply to a topic that has been dormant for 2 years. You can include a link to the earlier topic in your new post.

REFORMAT FIELDS=(F1:1,80,F2:1,80)
Note that both records are put into the 160 bytes. The check of pos 81 is to see if there is data or not.
Hope this helps,
User avatar
dick scherrer
Global moderator
Posts: 6308
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 90 times

Re: Re: moving of matched and unmatched records


Re: moving of matched and unmatched records

Postby BGronli » Tue Sep 11, 2012 7:45 pm

Thank you both, NicC and Dick, both responses helped.
Posts: 5
Joined: Tue Sep 11, 2012 6:40 pm
Has thanked: 0 time
Been thanked: 0 time

Re: moving of matched and unmatched records

Postby BillyBoyo » Wed Sep 12, 2012 5:03 am

DFSort has something a ?, which is the JOINKEYS match marker.

REFORMAT FIELDS=(F1:1,80,?,F2:1.80)

The values that the byte placed at the position of the ? can contain are B, on both files, 1, on file 1 only, and 2, on file 2 only.

INREC IFTHEN=(WHEN=(81,1,CH,EQ,C'2').BUILD=(82,80)

Would copy the whole of record 2 (of 80 bytes) to position 1 of the record when you have an F2 only.

Note that you can put the REFORMAT data in any order that you want:

REFORMAT FIELDS=(F2:1,4,F1:2.6,F2:91,107.F1:5,1,F2:1.80,?)

If that is the way you want the data, that is the way you can have it.
Global moderator
Posts: 3734
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 254 times


Return to Syncsort/Synctool


  • Related topics
    Last post