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

CURSOR with HOLD for DELETION of records


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
siddhartha biswas
Currently Banned

New User


Joined: 04 May 2008
Posts: 15
Location: india

PostPosted: Tue Aug 17, 2010 5:33 pm
Reply with quote

Hi All,

I need to declare a CURSOR with HOLD to delete record
WHERE DEPTNO = 'D11'.

I tried to find the exact syntax for this in DB2 manuals but could'nt find. Could anyone please provide the syntax for :

1. Declaring the cursor.
2. Fetching the cursor.

Thanks,
Sid
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 Aug 17, 2010 5:48 pm
Reply with quote

Syntax should have been readily available:

Google: cursor with hold in db2 - very first link

www.ibmmainframes.com/about31513.html
ibmmainframes.com/about43385.html
www.ibmmainframes.com/about25072.html
ibmmainframes.com/about6011.html
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 Compare 2 files and retrive records f... DFSORT/ICETOOL 0
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Join multiple records using splice DFSORT/ICETOOL 5
Search our Forums:

Back to Top