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 syntax for seeing the columns and data types of a table 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 difference between alias and synonym in db2?
What is iseries database?
What is drop table?
What is an instance in db2?
What is the maximum size of varchar data type in db2?
What is bind package and plan in db2?
Why do chiropractors use drop table?
What is copy pending status in db2?
Define db2.
How do you eliminate duplicate values in db2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Is it possible to create an Instance in DB2 using DB2 Control Center ?
How can you find out the # of rows updated after an update statement?