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

Horizontally Merging two datasets


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   This topic is locked: you cannot edit posts or make replies.
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
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

Moderator Emeritus


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

PostPosted: Wed Jul 08, 2009 12:28 am
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
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

Moderator Emeritus


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

PostPosted: Wed Jul 08, 2009 1:00 am
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. View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Mainframe Interview Questions

 


Similar Topics
Topic Forum Replies
No new posts Merging 2 datasets into one DFSORT/ICETOOL 1
No new posts scrolling horizontally TSO/ISPF 35
No new posts PL/I, VB Datasets and the RDW PL/I & Assembler 4
No new posts how to get list of all VSAM/non-VSAM ... JCL & VSAM 13
No new posts define 1 DCB parms for multiple outpu... JCL & VSAM 9
Search our Forums:

Back to Top