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
 

 

Combining datasets into one

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
prasenjit_dey

New User


Joined: 30 Apr 2008
Posts: 20
Location: Noida

PostPosted: Fri Mar 13, 2009 3:24 pm    Post subject: Combining datasets into one
Reply with quote

Hi,

I have two datasets:

FileA:

Lauren
Susan

FileB:

James
Anderson


I want to combine the two files so that the output file FileC has records as:

LaurenJames
SusanAnderson
Back to top
View user's profile Send private message

Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Fri Mar 13, 2009 10:30 pm    Post subject:
Reply with quote

ojdiaz,

Do you just want to match the records just by the order they came in each file? record 1 from file 1 should be tagged with record 1 in file 2 and record 2 from file 1 should be tagged with record 2 in file 2 and so on?

What is the LRECL/RECFM of the input files and desired output file?

Answer these questions and we will show you a way to do it
Back to top
View user's profile Send private message
sivasaras

New User


Joined: 29 Sep 2007
Posts: 90
Location: chenna/i-

PostPosted: Tue Mar 17, 2009 5:33 pm    Post subject: Reply to: Combining datasets
Reply with quote

HI,

You can use Merge file for combining datasets into one.

correct me if i am wrong,

Regards
siva
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


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

PostPosted: Tue Mar 17, 2009 9:26 pm    Post subject:
Reply with quote

Quote:
correct me if i am wrong


You're wrong. Consider yourself corrected.

MERGE can combine individual sorted input data sets into one sorted output data set. The question in this thread had nothing to do with that. It's about "joining" fields from two files. When the OP answers Kolusu's questions, we'll show how to do this.
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 DUMP DATASETS VS TRACE DATASETS! lind sh CICS 4 Tue Dec 06, 2016 11:31 pm
No new posts Single COPY CICS TS datasets and when... Kyle Carroll CICS 2 Tue Oct 11, 2016 9:47 pm
No new posts Finding unreferenced datasets without... Alan Playford JCL & VSAM 5 Tue Jul 12, 2016 9:07 pm
No new posts BDW in VB datasets harisukumaran JCL & VSAM 5 Sat May 28, 2016 9:46 am
No new posts How to sync memebers in some datasets... Lord.of.Wind Compuware & Other Tools 2 Thu Apr 21, 2016 12:48 pm


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