View previous topic :: View next topic
|
Author |
Message |
Sriramhari
New User
Joined: 11 May 2009 Posts: 17 Location: Bangalore
|
|
|
|
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 |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3051 Location: NYC,USA
|
|
|
|
Did you happen to check JOINKEYS? |
|
Back to top |
|
|
Sriramhari
New User
Joined: 11 May 2009 Posts: 17 Location: Bangalore
|
|
|
|
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 |
|
|
|