propagating a header into detail lines

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

propagating a header into detail lines

Postby migusd » Sat Dec 06, 2014 5:41 am

Hi guys,
I have a process that contains several files...
obviously each file contains a header record and multiple details lines.
When you read each file, is there a way to get a value out of the header, and propagate that value into their own detail lines?
I mean for each of the files read in the same step.

The purpose is to obviously identify specifically what file the detail records are coming from for subsequent sort.
I know, I am just testing the limits of the tool.

Any ideas or suggestions?

Posts: 40
Joined: Tue Dec 01, 2009 9:26 pm
Has thanked: 6 times
Been thanked: 0 time

Re: propagating a header into detail lines

Postby BillyBoyo » Sat Dec 06, 2014 1:32 pm

Yes. Use IFTHEN=(WHEN=GROUP,BEGIN= to identify the header and PUSH= to extend the records to include the data from the header. You may need to relocate the data once you have the detail record,. If variable records, do the extension at the "front" of the record (use IFTHEN=(WHEN=INIT to make new space ready for the PUSH=) and if fixed at the end.

These users thanked the author BillyBoyo for the post:
migusd (Sun Dec 07, 2014 10:11 am)
Global moderator
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Return to Syncsort/Synctool


  • Related topics
    Last post