JOIN 3 FILES USING JOINKEYS



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

JOIN 3 FILES USING JOINKEYS

Postby avinashmusic » Thu Sep 25, 2014 8:03 pm

Can we join 3 files using JOINKEYS in a single step?
avinashmusic
 
Posts: 21
Joined: Tue Dec 24, 2013 4:33 pm
Has thanked: 0 time
Been thanked: 0 time

Re: JOIN 3 FILES USING JOINKEYS

 

Re: JOIN 3 FILES USING JOINKEYS

Postby BillyBoyo » Thu Sep 25, 2014 8:45 pm

Yes and No.

No, you can't specify three JOINKEYS statements.

Yes, you may be able to concatenate two files on on JOINKEYS and arrange to distinguish between the records. Depends on the detail of what you want.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post