IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Combine more Files into One


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Sriramhari

New User


Joined: 11 May 2009
Posts: 17
Location: Bangalore

PostPosted: Tue Apr 29, 2014 11:38 am
Reply with quote

Hi All,
Here a requirement which requires combining more than one file into a single file.
Input files:
File 1: (Unique Acct. Numbers) - rec length : 80
Acct1
Acct2
Acct3
Acct4
File 2: (Acct number will be repeated, sorted by act num) FB, Recl : 500
Acct1 Error1
Acct1 Error2
Acct2 Error2
...
File 3: (Acct number will be repeated, Sorted by act num) FB, Recl : 500
Acct1 Update T1
Acct1 Update T2
Acct1 Update T3
..
like that we have 2 more files all are FB, Recl : 500.
Expected Output:
Acct1 File2_Info File3_Info File4_Info File5_Info

like below:
Acct1 Acct1 Error1 Acct1 Update T1
------ Acct1 Error2 Acct1 Update T2
------ --------------- Acct1 Update T3
Acct2 Acct2 Error2

Please share any inputs on how to combine the information into a single file in Jcl or Sort, instead of Rexx or cobol.

Thanks,
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2673
Location: NYC,USA

PostPosted: Tue Apr 29, 2014 12:00 pm
Reply with quote

Did you happen to check JOINKEYS?
Back to top
View user's profile Send private message
Sriramhari

New User


Joined: 11 May 2009
Posts: 17
Location: Bangalore

PostPosted: Tue Apr 29, 2014 12:11 pm
Reply with quote

Thank you for a hint. Yes checked with Joinkeys, but Join keys need to use multiple times. File1 with File2 then get Output file: JoinF12. Then do an another Join with JoinF12 & File 3.. continue.

'm getting an answer in multiple steps, thought of checking Is it will be any one or two step solution.

Thanks,
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files replace data in 1st f... DFSORT/ICETOOL 4
No new posts Merging 2 files but ignore duplicate... DFSORT/ICETOOL 1
No new posts Print report for each record from mul... CA Products 1
No new posts Get two files from one file with diff... DFSORT/ICETOOL 10
This topic is locked: you cannot edit posts or make replies. I HAVE 2 INPUT FILES WITH SAME LAYOUT... COBOL Programming 6
Search our Forums:

Back to Top