Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Combine more Files into One

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
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    Post subject: Combine more Files into One
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

Senior Member


Joined: 21 Sep 2010
Posts: 1649
Location: NY,USA

PostPosted: Tue Apr 29, 2014 12:00 pm    Post subject:
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    Post subject: Reply to: Combine more Files into One
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    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm
No new posts High CPU consumption Job using IAM fi... aswinir JCL & VSAM 15 Thu Dec 01, 2016 8:28 pm
No new posts Match or compare two files in VB Format anatol DFSORT/ICETOOL 14 Thu Nov 03, 2016 7:41 pm
This topic is locked: you cannot edit posts or make replies. How to use 2 input files in control c... Gunapala CN DFSORT/ICETOOL 23 Thu Oct 13, 2016 3:42 pm
No new posts Adding records from two files into on... shiitiizz SYNCSORT 4 Mon Sep 19, 2016 8:41 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us