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

what is cursor withhold option?


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
kvskris
Currently Banned

New User


Joined: 16 Sep 2006
Posts: 12

PostPosted: Sat Dec 23, 2006 9:31 am
Reply with quote

hello everybody,


i want to know about what is the use of using the cursor withhold option in
db2.

thanking you all,

kumar
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1448
Location: Chicago, IL

PostPosted: Sat Dec 23, 2006 12:00 pm
Reply with quote

From the manuals...
Back to top
View user's profile Send private message
Yuvaraj BP

New User


Joined: 12 Oct 2006
Posts: 12
Location: Bangalore

PostPosted: Sun Dec 24, 2006 7:01 am
Reply with quote

i know only the theoritical part of it and you should bear with me for my length explaination...

for an optimized and safer program to achieve concurrency and consistency of the data base according to my knowledge we liberally need to use Commit work and Rollback work statement accordingly, but while using cursors, if you use any of these statement, the cursor by default gets closed, and by any chance you need the cursor to continue with its activity, you can use the option of OPEN CURSOR WITH HOLD option with which the cursor will not close by default when it encounters commit or roll back statements
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 -> Mainframe Interview Questions

 


Similar Topics
Topic Forum Replies
No new posts SCOPE PENDING option -check data DB2 2
No new posts OUTFIL with SAVE option DFSORT/ICETOOL 7
No new posts CICS vs LE: STORAGE option CICS 0
No new posts INSYNC option with same function as I... JCL & VSAM 0
No new posts Option DYNALLOC second parameter. DFSORT/ICETOOL 11
Search our Forums:

Back to Top