What is the significance of the CURSOR WITH HOLD clause in
a cursor declaration?
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
Which isolation level provides maximum concurrency?
How do I import a csv file into db2?
What is load utility in db2?
What is the meaning concurrency in the db2 database?
How do I copy a table in db2?
How do you select a row using indexes in db2?
What is the difference between cursor stability and repeatable read isolation levels?
How connect db2 database to datastage?
Describe major components of db2?
What is a buffer in memory?
Define declaration generator (dclgen).
How to create backup table in db2?
What is table space in db2?
what is the role of the cursor in db2?
What is the use of db2 optimizer?