DBA > Job Interview Questions > DB2 ( IBM Database 2 ) Interview Questions

What is the significance of the CURSOR WITH HOLD

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

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

The clause avoids closing the cursor and respositioning it to the last row processed when the cursor is reopened.

(Continued on next question...)

Other Job Interview Questions