How do you leave the cursor open after issuing a COMMIT?
(for DB2 2.3 or above only)
Answers were Sorted based on User's Feedback
Answer / s
If you like the cursor maintain the position even after the
commit, CURSOR is defined WITH HOLD.
| Is This Answer Correct ? | 4 Yes | 0 No |
Explain various types of locks in db2?
What is db2 and what is the use of db2 optimizer?
What is the use of runstats in db2?
How to view db2 table structure?
can we drop column from a table
What is runstats utility in db2?
What is the purpose of the WHENEVER statement?
What is image copy in db2?
What is Declaration Generator(DCLGEN)?
What is the use of dclgen in db2?
How can deadlocks be resolved?
What is commit in db2?