help: join 2 files and overlay using data from one of files?



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

help: join 2 files and overlay using data from one of files?

Postby sanekpv » Fri Mar 04, 2011 7:47 pm

Please, advice

i am join 2 files, and I want to overlay using data from one of this files
example:
JOINKEYS FILES=F1,FIELDS=(1,17,A)
JOINKEYS FILES=F2,FIELDS=(1,17,A),INCLUDE=(22,2,CH,EQ,C'1A')
REFORMAT FIELDS=(F1:1,255,F2:1,255),FILL=X'FF'
JOIN UNPAIRED
SORT FIELDS=COPY
INREC IFTHEN=(WHEN=INIT,....),
IFTHEN=(WHEN=(.....),
OVERLAY=(10:C'111'))
instead of oVERLAY=(10:C'111')) I need OVERLAY=(10:F1:01,02))
I need to take data from F1 file current record instead of the constant C'111' string.
OVERLAY=(10:F1:01,02)) ==> is illigal
how can I do it

Thanks
sanekpv
 
Posts: 1
Joined: Fri Mar 04, 2011 7:17 pm
Has thanked: 0 time
Been thanked: 0 time

Re: help: join 2 files and overlay using data from one of fi

Postby Alissa Margulies » Fri Mar 04, 2011 11:43 pm

Try specifying
OVERLAY=(10:1,2)
If that does not produce the desired results, please indicate what is not correct and provide your complete control statements.
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 3 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post