How do you leave the cursor open after issuing a COMMIT?
(for DB2 2.3 or above only)
Answer Posted / a.roselin
CURSOR WITH HOLD Option
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the difference between bind and rebind in db2?
What are the rules for db2 programming?
How to check last update on table in db2?
What is the use of value function?
What is database reorganization?
What is ibm db2 client?
i want to maintain uniqueness on pdf without make lf??????????
What is phantom read in db2?
What is cascading rollback?
What is consistency token in db2?
What is the use of db2 optimizer?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What are the uses of db2 optimizer?
What does a deadlock mean in DB2?