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

mass delete in production


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
mailsaurabh.tripathi

New User


Joined: 22 May 2008
Posts: 56
Location: hyderabad

PostPosted: Wed Mar 04, 2009 3:26 pm
Reply with quote

for mass insert we have load utility, how can we use the existing utilities for selective mass delete? i guess the discard option can be of use. plz suggest, and provide your invaluable help.

thnx
Back to top
View user's profile Send private message
Srihari Gonugunta

Active User


Joined: 14 Sep 2007
Posts: 295
Location: Singapore

PostPosted: Wed Mar 04, 2009 4:29 pm
Reply with quote

Saurabh,
You can probably use DSNTIAD utility to delete from multiple tables at a time if I understand your question correctly.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India

PostPosted: Wed Mar 04, 2009 5:57 pm
Reply with quote

Saurabh,

With LOAD utility itself you can do it. But, why in PRODUCTION.

Sushanth
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 -> DB2

 


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 Mass JCL release via IDZ tool(eclipse... CA Products 1
Search our Forums:

Back to Top