Interested to Buy Any Domain ? << Click Here >> for more details...
What is the significance of the CURSOR WITH HOLD clause in
a cursor declaration?
- 4 Answers
- 30533 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 |
Name some fields from SQLCA
What is the function of the Data Manager?
What is the difference between static and dynamic SQL?
How do u achieve record level locking in DB2 versions when record level locking is not allowed?
What is an inner join, and an outer join ?
What is rebind in db2?
what is the difference between join and union?
What is a bind card?
What does sqlcabc has?
What do you do to keep the cursor from closing after a commit?
How do you find the maximum value in a column in db2?
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
COBOL 
