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

Delete mebers from production PDS usinf other pds


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
laxmi16

New User


Joined: 02 Jul 2012
Posts: 3
Location: india

PostPosted: Tue Jul 17, 2012 12:01 pm
Reply with quote

I have the list of members(100) to be deleted in one PDS. I need to delete that list from production pds .
CAn i have the single job to delete them from production pds.
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Tue Jul 17, 2012 12:54 pm
Reply with quote

Did you try using IEHPROGM, IDCAMS, yes - what happened? No, please try now.
Back to top
View user's profile Send private message
laxmi16

New User


Joined: 02 Jul 2012
Posts: 3
Location: india

PostPosted: Tue Jul 17, 2012 2:01 pm
Reply with quote

I tried IDCAMS. In my jcl i am giving the statement as
DELETE 'MY.Prd.PDS(TEST1)'
DELETE ''MY.PRD.PDS(TEST2)'
..
...

like wise i am repeating the 100 entries..It worked.

Instead of repeating the member names in the PDS.. Is there any way if i mention
input as - My personal PDS which have the members to be deleted from production PDS.
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL

PostPosted: Tue Jul 17, 2012 3:41 pm
Reply with quote

There are a number of solutions using *Sort, Rexx, and/or compiled-language programs. The one that immediately comes to my mind is:
  1. Create a skeleton with your DELETE control card using a variable and enclosed in a DOT construct.
  2. Write a little Rexx to read your list of members to delete into an ISPF table.
  3. Tailor the skeleton and SUBMIT the resulting JCL.

but, as I say, there are others. Search this board, and choose the one with which your skills make you comfortable.
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 18, 2012 6:10 am
Reply with quote

Hello,

Before doing Anything to Any dataset, you need to make sure there is a current backup!

Create a playground dataset and test your process.

Then schedule a time when the Production dataset will not be in use, create a backup, and run the process.
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 DELETE SPUFI DB2 1
No new posts DSNTIAUL driven delete IBM Tools 0
No new posts How to delete a user's alias from the... JCL & VSAM 11
No new posts Monitoring production job progress. N... JCL & VSAM 4
No new posts Delete file row if blanks in the firs... DFSORT/ICETOOL 5
Search our Forums:

Back to Top