What is the significance of the CURSOR WITH HOLD clause in
a cursor declaration?
Answers were Sorted based on User's Feedback
Answer / abhisek
As soon as the COMMIT statement is executed in a
program,the cursor gets automatically closed,So we need to
give CURSOR WITH HOLD clause,in order to keep it open after
execution of the COMMIT statement.
Is This Answer Correct ? | 43 Yes | 2 No |
Answer / ss
To remain cursor open after commit statement execution
Is This Answer Correct ? | 33 Yes | 0 No |
Answer / yogendra shinde
Hi,
CURSOR with WITHOLD is very useful where we need to use
more than 1 database simultaneously.
Suppose you are reading or fetching a value from local
database and updating those retrieved values in a remote
DB. In such case when you connect to remote DB, you need to
use WITHOLD for local db. So that you don't loose the
cursor position for local db.
For further ref. do read more about CONNECT.
Is This Answer Correct ? | 10 Yes | 2 No |
Answer / mainframe virumbi
The answers given above is correct only. Adding those, we
cant execute sql statements other than select, after commit
is encountered.
Is This Answer Correct ? | 8 Yes | 1 No |
What is db2? Explain.
What is a db2 cursor?
What is the SQL Communications Area and what are some of its key fields?
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
What is performance tuning db2?
What is the use of DELGEN in DB2? Can we Write the program with out using it?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
Can we insert update delete in view?
Explain in brief how does db2 determine what lock-size to use?
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
What is a page?
how will you retrieve first record in table