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

Merge data from diffrent members of PDS into single member


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
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
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
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
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

Global Moderator


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

PostPosted: Wed Jul 11, 2007 4:08 pm
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
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

Global Moderator


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

PostPosted: Wed Jul 11, 2007 6:00 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Store the data for fixed length COBOL Programming 1
No new posts Data set Rec-Cnt and Byte-Cnt Testing & Performance 2
No new posts SCOPE PENDING option -check data DB2 2
No new posts Check data with Exception Table DB2 0
No new posts JCL EXEC PARM data in C Java & MQSeries 2
Search our Forums:

Back to Top