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

Mass Delete of PDS memebers?


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

New User


Joined: 24 Oct 2008
Posts: 16
Location: Bangalore

PostPosted: Thu Aug 20, 2009 11:32 am
Reply with quote

Hi All,

I would like to delete some members from PDS using IDCAMS.

I tryied using below job
=================
//STEP0010 EXEC PGM=IDCAMS,COND=(0,NE)
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSIN DD *
DELETE UGCG1CB.V823.CLEANLIB(PGC*)
/*
==================

This job throughing below error
==========
DELETE (UGCG1CB.V823.CLEANLIB(PGC*))
IDC3203I ITEM 'UGCG1CB.V823.CLEANLI' DOES NOT ADHERE TO RESTRICTIONS
IDC3202I ABOVE TEXT BYPASSED UNTIL NEXT COMMAND. CONDITION CODE IS 12

IDC0002I IDCAMS PROCESSING COMPLETE. MAXIMUM CONDITION CODE WAS 12
===========

I tried to delete one member using this JOB that time it went fine.

But i want to delete multiple members at a time.

Can you please help me out.

Thanks,
Vijay
Back to top
View user's profile Send private message
superk

Global Moderator


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

PostPosted: Thu Aug 20, 2009 11:34 am
Reply with quote

No wildcards. Just code one DELETE record for each member name.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Thu Aug 20, 2009 11:37 am
Reply with quote

I'm sure that I posted some code to do this a while ago. Maybe the search button isn't working.
Back to top
View user's profile Send private message
nevilh

Active User


Joined: 01 Sep 2006
Posts: 262

PostPosted: Thu Aug 20, 2009 9:18 pm
Reply with quote

you can do this using ispf . IN option 3.4 browse the dataset and then issue S PGC* DEL
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Thu Aug 20, 2009 9:20 pm
Reply with quote

Quote:
you can do this using ispf . IN option 3.4 browse the dataset and then issue S PGC* DEL


beware of flaky finger action icon_cool.gif
Back to top
View user's profile Send private message
MBabu

Active User


Joined: 03 Aug 2008
Posts: 400
Location: Mumbai

PostPosted: Fri Aug 21, 2009 3:44 am
Reply with quote

Won't DEL invoke the DELETE command for each member and require an enhanced member list? That would be a bit slow and leave you with the data set allocated disp=old. Try S PGC* D to use the built-in ISPF delete.
Back to top
View user's profile Send private message
Pete Wilson

Active Member


Joined: 31 Dec 2009
Posts: 582
Location: London

PostPosted: Wed Jan 06, 2010 8:41 pm
Reply with quote

If you have the PDSMAN product:

//STEP1 EXEC PGM=PDSM10,PARM='EMPTYO'
//PDSMPDS DD DSN=PDS.NAME,
// DISP=SHR
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1702
Location: Australia

PostPosted: Thu Jan 07, 2010 3:38 am
Reply with quote

Hi DinoZos,

Quote:
I would like to delete some members from PDS using ID


the request was to delete SOME and not all of the members.



Gerry
Back to top
View user's profile Send private message
Pete Wilson

Active Member


Joined: 31 Dec 2009
Posts: 582
Location: London

PostPosted: Thu Jan 07, 2010 4:38 pm
Reply with quote

gcicchet - Oooops missed that. As ever the devil is in the detail!

Perhaps this might be better, although the list must be generated first of course:
//DELMEMB EXEC PGM=PDSM32
//PDSMPDS DD DISP=SHR,DSN=PDS.NAME
//PDSMRPT DD SYSOUT=*
//SYSIN DD *
DELETE MEMONE
DELETE MEMTWO
DELETE MEMTHREE
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 Mass JCL release via IDZ tool(eclipse... CA Products 1
No new posts Delete file row if blanks in the firs... DFSORT/ICETOOL 5
Search our Forums:

Back to Top