Need a way to avoid closing of cursor.

chitra_chaturvedi · New User Joined: 24 Jul 2007 Posts: 18 Location: india

Hi,

Is there any way through which I can avoid closing of cursor even after issuing ROLLBACK.

I know WITH HOLD does not work here. Ny other options????

Thanks

Anuj Dhawan · Posted: Tue Oct 12, 2010 7:55 pm

dbzTHEdinosauer · Posted: Tue Oct 12, 2010 8:45 pm

if you are not working on iSeries (big pc) or db2 for LUW,
then the mainframe z/OS manuals are applicable:

db2 vsn7 ROLLBACK

db2 vsn9.1 - PDF lookfor ROLLBACK

both essentially say the cursors are closed in batch.
in CICS or IMS, if you issue savepoints, the cursors are left open, but the cursor position is not changed - which means - you have to reposition the cursor.

chitra_chaturvedi · New User Joined: 24 Jul 2007 Posts: 18 Location: india

Thanks for your suggestions Anuj and DBZ..

Anuj Dhawan · Posted: Fri Oct 15, 2010 8:43 pm

Please notice what Dick has said in his post. That's the key part to look at before you thank us...