Page 1 of 1

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

PostPosted: Fri Mar 04, 2011 7:47 pm
by sanekpv
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

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

PostPosted: Fri Mar 04, 2011 11:43 pm
by Alissa Margulies
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.