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
- 30278 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 the difference between bind and rebind in db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is a buffer in memory?
What is dclgen in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
Explain correlated sub-queries.
How is the value function used?
How to rename a table in DB2 ?
What is the use of value function?
What is coalesce in db2?
How does a cursor work?
What is drop table?
What is the maximum size of a char data type in db2?
How is a typical db2 batch pgm executed?
What is dbrm? What it contains?
