What is the significance of the CURSOR WITH HOLD clause in
a cursor declaration?

Answer Posted / ss

To remain cursor open after commit statement execution

Is This Answer Correct ?    33 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about rct.

858


What does reorg do in db2?

775


What is the role of schema in the db2 database?

906


What is a plan and package in db2?

839


What is difference between alias and synonym in db2?

855


What is a page in db2?

796


What is difference between rollback and commit?

871


What is the syntax for FETCH in DB2 ?

907


What is meant by explain?

850


How to find the number of rows in a db2 table?

844


Which component is responsible for processing sql statements and selecting access paths?

892


What is bind in db2?

792


How do we specify index to include or not during bind process.

1856


What is buffer pool in the db2 database?

842


What is the use of db2 optimizer?

821