What is the significance of the CURSOR WITH HOLD clause in
a cursor declaration?
- 4 Answers
- 29320 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
Explain in detail about buffer manager and its functionalities?
How do I start db2 in windows?
What is host variable?
What is collection in db2 bind?
What is database manager in db2?
Which is faster delete or truncate?
What is page size in db2?
How can we read records for specific member in CL? AND rpg?
Why do we use cursor?
What are union and union all?
What is the use of runstats in db2?
Why cursor is used in db2?
What is a trigger in the db2 database?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
Discuss about db2 bind?
