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


Please Help Members By Posting Answers For Below Questions

What is the syntax for seeing the columns and data types of a table in the db2 database?

576


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

1797


What is difference between alias and synonym in db2?

635


What is iseries database?

593


What is drop table?

580






What is an instance in db2?

561


What is the maximum size of varchar data type in db2?

643


What is bind package and plan in db2?

591


Why do chiropractors use drop table?

656


What is copy pending status in db2?

632


Define db2.

664


How do you eliminate duplicate values in db2?

679


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

712


Is it possible to create an Instance in DB2 using DB2 Control Center ?

620


How can you find out the # of rows updated after an update statement?

633