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?
Thanks...

Miguel
migusd
 
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

 

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


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post