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

Merge files side by side using SORT


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

New User


Joined: 24 Sep 2006
Posts: 9
Location: CALCUTTA

PostPosted: Mon Oct 16, 2006 12:41 pm
Reply with quote

Hi All,

Can anybody tell me how to merge two datasets side by side using JCL only(I mean no EZTP OR REXX).
Actually I have two datasets dataset1 containing A,B,C fields and dataset2 containg A,D,E fields.A field contains same values sorted in the same manner.I want to produce a dataset out of this which contain A,B,C,D,E.

I have tried merge using SORT utility, but it did not produce what i want. icon_sad.gif

Earliest reply will highly be appreciated..

Thanks,
- SUMAN.
Back to top
View user's profile Send private message
surya_pathaus

Active User


Joined: 28 Aug 2006
Posts: 110

PostPosted: Mon Oct 16, 2006 1:13 pm
Reply with quote

Suman,

Here is the link which is posted in this forum very recently.

http://ibmmainframes.com/viewtopic.php?t=7772
Back to top
View user's profile Send private message
SumanM

New User


Joined: 24 Sep 2006
Posts: 9
Location: CALCUTTA

PostPosted: Mon Oct 16, 2006 3:25 pm
Reply with quote

Hi Surya,

thanx for responding ... but the link is not available now.so could you please copy/paste the code here.

-Suman
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 Oct 16, 2006 9:17 pm
Reply with quote

The information is in the "Join fields from two files on a key" Smart DFSORT Trick at:

www.ibm.com/servers/storage/support/software/sort/mvs/tricks/
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 How to split large record length file... DFSORT/ICETOOL 10
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 JCL sort card - get first day and las... JCL & VSAM 9
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
Search our Forums:

Back to Top