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
- 30520 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
Name the various locking levels available?
If I have a view which is a join of two or more tables, can this view be updateable?
Can we insert update delete in view?
What is catalog database in db2?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How do I add a column to a table in db2?
What is release/acquire in bind?
What is dbrm?
What is copy pending status in db2?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is a Foreign Key?
What is the difference between plan and package in db2?
On which levels locks can be applied?
Explain about mirror activator disk mirroring?
Define buffer pool.
