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
 

 

Merge data from diffrent members of PDS into single member

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
swami_entc

New User


Joined: 07 Jun 2007
Posts: 3
Location: Mumbai

PostPosted: Wed Jul 11, 2007 3:45 pm    Post subject: Merge data from diffrent members of PDS into single member
Reply with quote

I have 10 members in a PDS, I want to merge all the 10 members and create a single member in the same PDS. Is there any Utility to do this?
Back to top
View user's profile Send private message

saiprasadh

Active User


Joined: 20 Sep 2006
Posts: 154
Location: US

PostPosted: Wed Jul 11, 2007 4:01 pm    Post subject:
Reply with quote

Hi,

You can do that using Rexx.


Thanks
Sai
Back to top
View user's profile Send private message
swami_entc

New User


Joined: 07 Jun 2007
Posts: 3
Location: Mumbai

PostPosted: Wed Jul 11, 2007 4:07 pm    Post subject:
Reply with quote

saiprasadh wrote:
Hi,

You can do that using Rexx.


Thanks
Sai



I am not familiar to REXX.
Can we do it using JCL?
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Wed Jul 11, 2007 4:08 pm    Post subject: Re: To merge data from diffrent mebers of PDS into single me
Reply with quote

You could:

1. Use IEBGENER/DFSORT/ICETOOL to copy each of the 10 members into one single sequential dataset (DISP=MOD, of course), and then copy that dataset into the one member.

2. You could use IEBPTPCH to "PUNCH" the PDS into a single sequential dataset, clean up the output with DFSORT, and then use IEBUPDTE to create the new member.

3. You could do this programatically as mentioned above, using REXX, or using ISPF Library Management (LM) services in any program.

4. I'll bet its doable using SAS.

5. Or, just use EDIT.
Back to top
View user's profile Send private message
swami_entc

New User


Joined: 07 Jun 2007
Posts: 3
Location: Mumbai

PostPosted: Wed Jul 11, 2007 4:26 pm    Post subject: Re: To merge data from diffrent mebers of PDS into single me
Reply with quote

superk wrote:
You could:

1. Use IEBGENER/DFSORT/ICETOOL to copy each of the 10 members into one single sequential dataset (DISP=MOD, of course), and then copy that dataset into the one member.

2. You could use IEBPTPCH to "PUNCH" the PDS into a single sequential dataset, clean up the output with DFSORT, and then use IEBUPDTE to create the new member.

3. You could do this programatically as mentioned above, using REXX, or using ISPF Library Management (LM) services in any program.

4. I'll bet its doable using SAS.

5. Or, just use EDIT.


Hi,
1. If we use IEBGENER we have to give PDS name and its member name,
I have to merge all the members of that PDS into a single member so is
it possible by giving a PDS name only?

2. Can we avoid use of sequential dataset?
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Wed Jul 11, 2007 6:00 pm    Post subject: Re: To merge data from diffrent mebers of PDS into single me
Reply with quote

swami_entc wrote:

1. If we use IEBGENER we have to give PDS name and its member name, I have to merge all the members of that PDS into a single member so is it possible by giving a PDS name only?

No, not that I can see.

swami_entc wrote:

2. Can we avoid use of sequential dataset?

Yes. I thought there might be an issue with contention, but it looks like the input and output can be to the same PDS with DISP=SHR.
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Data replication from multiple Db2 ta... kishpra DB2 5 Mon Mar 27, 2017 9:58 pm
No new posts Splitting of single report to seperat... abdulrafi TSO/ISPF 4 Mon Mar 27, 2017 3:59 pm
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm
No new posts IMS DB-How to update a record (a sing... Nic Clouston IMS DB/DC 9 Thu Mar 09, 2017 4:38 pm


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