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 |
What are the uses of db2 optimizer?
What is meant by index cardinality?
What are the Isolation levels possible ?
What are foreign keys in db2?
What is a DBRM, PLAN ?
what is the use of commit ? and what is the syntax?
What is index cardinality?
can we update the table by using cursors can anyone post the query?
What is catalog database in db2?
What are leaf pages?
How do you select a row using indexes in db2?
What is the difference between oracle and db2?