What is the significance of the CURSOR WITH HOLD clause in
a cursor declaration?
Answer Posted / abhisek
As soon as the COMMIT statement is executed in a
program,the cursor gets automatically closed,So we need to
give CURSOR WITH HOLD clause,in order to keep it open after
execution of the COMMIT statement.
| Is This Answer Correct ? | 43 Yes | 2 No |
Post New Answer View All Answers
How do I delete a table in database?
How do I create a view in db2?
What are types of indexes?
What kind of database is db2?
What is the maximum number of columns in a db2 table?
What is a db2 collection?
How do you find the maximum value in a column 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
What does runstats do in db2?
What is database reorganization?
Can you use max on a char column?
What is a db2 schema?
What is db2 instance?
What is dbrm?
What is cobol db2?