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
- 30361 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
Why cursor is used in db2?
How can you find out the # of rows updated after an update statement?
What is a db2 collection?
Give the name of some fields form sqlca.
How to get the ddl of a table in db2?
How do I import data from excel to db2?
Why db2 is called db2?
What is the role of union all and union
Explain package in db2 and its advantages?
How to restart a DB2 program?
What is the clustering index in the db2 database?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What are types of indexes?
What is nvl in db2?
What is the role of data manager in the db2 database?
