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

is there any FOR DELETE OF option in DECLARE CURSOR ?
IBM Mainframe Forums -> DB2
Post new topic   This topic is locked: you cannot edit posts or make replies. Quick References
View previous topic :: View next topic  
Author Message
alluri12

New User


Joined: 15 Aug 2006
Posts: 44
Location: Virginia, USA
PostPosted: Thu Jun 19, 2008 9:05 pm
 Reply with quote
Actually i want to DELETE records that are FETCHED from the DECLARE CURSOR based on certain Creteria.

Similar to FOR UPDATE OF is there any option to specify FOR DELETE in DECLARE CURSOR

if there is any option like that, will that make any difference at run time.
Back to top
View user's profile Send private message
UmeySan

Active Member


Joined: 22 Aug 2006
Posts: 771
Location: Germany
PostPosted: Thu Jun 19, 2008 9:19 pm
 Reply with quote
Hi alluri12 !

Use the "where-current-of" option in the EXEC SQL DELETE command.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies. 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 SCOPE PENDING option -check data DB2 2
No new posts OUTFIL with SAVE option DFSORT/ICETOOL 7
No new posts How to delete a user's alias from the... JCL & VSAM 11
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us