JOIN File Concatenation



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

JOIN File Concatenation

Postby ajuatsgp » 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:
//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
ajuatsgp
 
Posts: 82
Joined: Thu May 20, 2010 6:50 pm
Has thanked: 0 time
Been thanked: 0 time

Re: JOIN File Concatenation

Postby BillyBoyo » Tue Jun 26, 2012 9:18 pm

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

Re: JOIN File Concatenation

Postby skolusu » Tue Jun 26, 2012 9:58 pm

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
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times

Re: JOIN File Concatenation

Postby ajuatsgp » Tue Jun 26, 2012 10:22 pm

Thanks all.
ajuatsgp
 
Posts: 82
Joined: Thu May 20, 2010 6:50 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post