What does WITH HOLD option do ?

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

(Continued from previous question...)

What does WITH HOLD option do ?

Q: What does WITH HOLD option do ? forces cursor to close after commit b.Keeps cursor open after commit c.Does not allow cursor to close till all rows are fetched d.Locks the cursor e.None of the above

A: Keeps cursor open after commit

(Continued on next question...)

Other Job Interview Questions

• How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause.)
• What does WITH HOLD option do ?
• How would you retrieve rows from a DB2 table in embedded SQL? –
• What is a thread?
• What is index cardinality? –
• Is it mandatory to use DCLGEN? If not, why would you use it at all?
• What is CHECK PENDING ?
• What is the meaning of underscore ( ‘_’ ) in the LIKE statement? –
• What is EXPLAIN?
• What are correlated subqueries?
• More...