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
 

 

Horizontally Merging two datasets

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
ashok4u_it

New User


Joined: 12 Mar 2008
Posts: 53
Location: Chennai

PostPosted: Tue Jul 07, 2009 11:39 pm    Post subject: Horizontally Merging two datasets
Reply with quote

Hi,

Can anyone please help me out to merge two datasets horizontally using DFSORT as shown below.
For Example,
Data - 1
ID Name
001 Ashok
002 Bharath
002 Sami
003 Anand

Data - 2
DOB ID
07MAR1984 001
02JAN1982 002
04APR1981 002
17NOV1985 003

The output is,
Data - 3
ID Name DOB
001 Ashok 07MAR1984
002 Bharath 02JAN1982
002 Sami 04APR1981
003 Anand 17NOV1985

Is there a DFSORT to achieve this output.
Note:-
Please make note, I want this to be done in DFSORT not in ICETOOL.

Tnaks in Advance

Regards
Ashok Kumar.K
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Jul 08, 2009 12:28 am    Post subject:
Reply with quote

Hello,

ICETOOL is part of the DFSORT product. It has been part of the product for over 15 years (iirc).

Tell the interviewer/manager that not using the product as installed makes very little sense (according to a very senior person of your acquaintance).
Back to top
View user's profile Send private message
ashok4u_it

New User


Joined: 12 Mar 2008
Posts: 53
Location: Chennai

PostPosted: Wed Jul 08, 2009 12:59 am    Post subject: Reply to: Horizontally Merging two datasets
Reply with quote

Sorry, mistakenly i posted this problem here.
Sorry for the mistake caused.

Regars
Ashok Kumar.K
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Jul 08, 2009 1:00 am    Post subject: Reply to: Horizontally Merging two datasets
Reply with quote

Thanks for the update - i'll lock this one.

d
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions 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