Questions on DB2 - Cursor

xknight · Posted: Mon Sep 06, 2010 11:12 am

While using cursor as per the below process,

Declare

Open Cursor

Fetch Cursor

---> Update records

---> Commit has been used

Close Cursor

If we use Commit explicitly, it will close the cursor technically, after that if we close the cursor again as a cursor process, will that give -502 ? or skips the step and run.

dick scherrer · Posted: Mon Sep 06, 2010 11:31 am

Hello,

It appears that you have some misconceptions. . .

Suggest you read here:
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnsqj10/5.42

Scroll down to the section WITHOUT HOLD or WITH HOLD .

xknight · Posted: Mon Sep 06, 2010 11:44 am

Hello Dick,

First, Thank you very much for the manual link, but i still confused the way it works.

Using "WITHOUT HOLD" , we get -502 error after giving commit and close the cursor again as per process. Am i right?

Please suggest.

Regards,
Xavier