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
What is the physical storage length of the data types date, time, and timestamp?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
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 is runstats db2?
What is sqlca’s maximum length?
Is it possible using max on a char column?
How can you find out the # of rows updated after an update statement?
How does a cursor work?
Explain what are the various isolation levels possible?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
List out the data types available.
How does cobol compile db2 program?
What is the use of reorg in db2?
Explain db2.
How to execute stored procedure in db2 command editor?