What is the significance of the CURSOR WITH HOLD clause in
a cursor declaration?
- 4 Answers
- 28499 Views
- I also Faced
- E-Mail Answers
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 are the 4 environments which can access DB2 ?
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
What are common abends
How do I import a csv file into db2?
What is PRIME TABLE and what are the uses of it
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
what is a plan and how do you refer the plan in the program?
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
What is Skeleton cursor table (SKCT)?
What is coalesce in db2?
What does reorg do in db2?
What is a synonym ?
COBOL 
