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: 4649
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: 4649
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 copying data without knowing location arunsoods DFSORT/ICETOOL 6 Thu Jul 20, 2017 1:03 pm
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am
No new posts NDM syntax checking without actually ... GAPX1 All Other Mainframe Topics 0 Wed Jun 07, 2017 2:36 am


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