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,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 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.
BGronli
 
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.

So:
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.
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