IBM Mainframe Forum

Mainframe Technical Support Forums

Skip to content


JOIN 3 FILES USING JOINKEYS



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

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
Top

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: 265 times
Top

Re: JOIN 3 FILES USING JOINKEYS

Postby sergeyken » Tue Nov 15, 2022 9:02 am

avinashmusic wrote:Can we join 3 files using JOINKEYS in a single step?

Try to use either ICETOOL, or SYNCTOOL, whatever is available to you.
Javas and Pythons come and go, but JCL and SORT stay forever.
User avatar
sergeyken
 
Posts: 438
Joined: Wed Jul 24, 2019 10:12 pm
Has thanked: 7 times
Been thanked: 40 times
Top
Post a reply

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post
Forum Rules|FAQ|Subscriptions|Bookmarks