IBM Mainframe Forum

by **ravi11081992** » Sat Jan 22, 2022 2:42 pm

Hi,

If I use 'cursor without hold' and
after fetching all the records if I issue commit without having a 'Close cursor' statement

Will it be an issue opening the cursor again when I run the program again

Please let me know

Thanks

by **prino** » Tue Jan 25, 2022 2:47 am

Why the flipping 'ell don't you try with a test program?

by **engh** » Tue Sep 20, 2022 6:07 pm

in case the answer is still awaited : yes, closing the cursor like committing the transaction causes the cursor pointer to be lost.
There is therefore no other solution than to specify "with hold" to avoid this inconvenience.

IBM Mainframe Forum

Commit issued without hold and without close cursor statemen

Commit issued without hold and without close cursor statemen

Re: Commit issued without hold and without close cursor stat

Re: Commit issued without hold and without close cursor stat