DB2 WITH HOLD option

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

Keeps cursor open after commit

Questions by radibioinfo   answers by radibioinfo

Showing Answers 1 - 4 of 4 Answers


  • Dec 4th, 2009

When a commit is issued by a program all the cursors opened by that program are closed, but WITH HOLD option is used to retain the cursor pointer, even if the commit is used.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions