JOIN File Concatenation
Posted: Tue Jun 26, 2012 9:06 pm
I am doing a JOIN using sort.
Can I give DD concatenation for one of my JOIN File.
EX:
is it possible to concatenate two files here in FILE1?
Thanks
Can I give DD concatenation for one of my JOIN File.
EX:
//SYSIN DD *
JOINKEYS F1=FILE1,FIELDS=(01,19,A)
JOINKEYS F2=FILE2,FIELDS=(18,19,A)
REFORMAT FIELDS=(F1:1,80,F2:1,57)
OPTION COPY
// *
//FILE1 DD DSN=ABC,DISP=SHR
DD DSN=DEF,DISP=SHR
//FILE2 DD DSN=XYZ,DISP=SHR
JOINKEYS F1=FILE1,FIELDS=(01,19,A)
JOINKEYS F2=FILE2,FIELDS=(18,19,A)
REFORMAT FIELDS=(F1:1,80,F2:1,57)
OPTION COPY
// *
//FILE1 DD DSN=ABC,DISP=SHR
DD DSN=DEF,DISP=SHR
//FILE2 DD DSN=XYZ,DISP=SHR
is it possible to concatenate two files here in FILE1?
Thanks