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

Combining two files


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

New User


Joined: 23 Feb 2006
Posts: 3
Location: pune

PostPosted: Mon Jul 14, 2008 3:25 pm
Reply with quote

Hi,

I want to combine the columns from the two files and generate a single output file. How can I do it through the JCL?

Ex: File A having col1, col2, col3, col4
File B having col5, col6, col7, col8

I need File C with the columns col1, col2, col3, col5, col6, col7

Thanks
U.H
Back to top
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India

PostPosted: Mon Jul 14, 2008 3:56 pm
Reply with quote

unnma,

Quote:
want to combine the columns from the two files and generate a single output file


This has been discussed so many times. Do search this forum for the keyword "SPLICE".

Try and post if you face any difficulty.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Mon Jul 14, 2008 9:34 pm
Reply with quote

UH,

Depending on what you want to do exactly, you can use the technique shown in the "Join fields from two files on a key" or "Join fields from two files record-by-record" Smart DFSORT Trick at:

Use [URL] BBCode for External Links
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(F1 & F2) and writ... JCL & VSAM 8
No new posts Write line by line from two files DFSORT/ICETOOL 7
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Merge two VSAM KSDS files into third ... JCL & VSAM 6
No new posts Joinkeys - 5 output files DFSORT/ICETOOL 7
Search our Forums:

Back to Top