Declare Cursor With Hold 1

[dja1]

I believe that declaring a CURSOR WITH HOLD means that the position within the cursor is retained even when a COMMIT is executed.

I can find this in the DB2 SQL Reference, however, I can't find anywhere that states if the WITH HOLD clause is NOT included, the cursor position is lost.
1) Does anyone know where this is documented?
2) Is the cursor closed on a COMMIT, or just re-positioned at the beginning?

 

[gregsimpson]

Hi dja1

The CURSOR is closed.

Take a look at the following link

http://www-3.ibm.com/software/data/db2/udb/ad/v7/adg/db2a0/frame3.htm#db2a031

Cheers
Greg

 

[dja1]

Greg
Thanks very much. Answer exactly as required. How are things with you? If you haven't guessed - David Allcott - Euler

 

[gregsimpson]

Hi Dave,

I didn't recognise your sign on to be honest. Hopefully your happpier with this answer than my intersect, when I "showed a willingness" to consult the manual"!! No browser access at work so Tek-tip only occasionally nowadays.

Things are okay. Renewed for another 6 months. Nice to hear from you again, trust everything is going okay for you too. Merry Xmas to all.

Cheers
Greg

probably get into trouble now for using Tek-tips as a message board. Merry Xmas to everyone else in the forum as well.