JOIN 3 FILES USING JOINKEYS

IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER
Post Reply Previous topicNext topic
avinashmusic
Posts: 21
Joined: Tue Dec 24, 2013 4:33 pm
Skillset: COBOL, JCL, VSAM, DB2, CICS
Referer: Google

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?
Top
BillyBoyo
Global moderator
Posts: 3805
Joined: Tue Jan 25, 2011 12:02 am
Skillset: Easytrieve Plus, Cobol, Utilities, that sort of stuff
Referer: Google

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.
Top
User avatar
sergeyken
Posts: 458
Joined: Wed Jul 24, 2019 10:12 pm
Skillset: Assembler, JCL, Utilities, PL/I, C/C++, DB2, SQL, REXX, COBOL, etc. etc. etc.
Referer: Internet search

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.
Top
Post Reply Previous topicNext topic
  • Similar Topics
    Replies
    Views
    Last post

Return to “DFSORT/ICETOOL/ICEGENER”