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
- 30097 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?
Mention some fields that are a part of sqlca.
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is runstats utility in db2?
Who uses db2?
Mention the definition of cobol in varchar field.
What is the role of union all and union
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
How and when does the db2 enforces the unique key?
How to check last update on table in db2?
What's The Percentage Free Space ?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Explain correlated sub-queries.
How do I connect my db2 database to ibm?
What is the role of schema in the db2 database?
