Page 1 of 1

JOIN File Concatenation

PostPosted: Tue Jun 26, 2012 9:06 pm
by ajuatsgp
I am doing a JOIN using sort.
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


is it possible to concatenate two files here in FILE1?

Thanks

Re: JOIN File Concatenation

PostPosted: Tue Jun 26, 2012 9:18 pm
by BillyBoyo
Yes, as long as they are suitable for concatenation. If VB, largest blocksize first. If FB all the same blocksize. No VSAM. No mix of VB/FB. Otherwise fine.

Re: JOIN File Concatenation

PostPosted: Tue Jun 26, 2012 9:58 pm
by skolusu
ajuatsgp,

Yes you can concatenate as long as you follow the rules of concatenation listed here

http://publibz.boulder.ibm.com/cgi-bin/ ... 6B0/12.1.6

Re: JOIN File Concatenation

PostPosted: Tue Jun 26, 2012 10:22 pm
by ajuatsgp
Thanks all.