Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 4650
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: 4650
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 security erase on RAID device steve-myers All Other Mainframe Topics 0 Sat Jan 13, 2018 6:41 am
No new posts Append the milliseconds to the data s... girishb2 DFSORT/ICETOOL 1 Thu Dec 21, 2017 9:07 pm
No new posts Moving a COMP-3 Variable to a Numeric... ajayachander COBOL Programming 2 Thu Dec 14, 2017 5:46 pm
No new posts Extract record for change in combinat... Trinadh DFSORT/ICETOOL 6 Thu Nov 23, 2017 3:32 pm
No new posts Fetching data from JHS as per the cur... arunsoods All Other Mainframe Topics 4 Wed Nov 22, 2017 1:54 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us