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
- 30324 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is db2 look?
What are the uses of db2 optimizer?
Explain about rct in db2?
How do I add a column to a table in db2?
What is the meaning concurrency in the db2 database?
Explain what are the various isolation levels possible?
What is db2 connect?
Can there be more than one cursor open for any program?
What is phantom read in db2?
How to check sequence on a table in db2?
What is the use of value function?
What is view db2?
What is the maximum length of sqlca?
Explain packages.
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
