AW: Cursor closed (probably by commit or rollback)

The SQL commit closes all Cursors that are open, except you specified WITH
HOLD in your Declare Statement:

Exec SQL Declare MyCusror with Hold for
Select ....;

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
Auftrag von mahefa randimbisoa
Gesendet: Friday, 07. January 2011 15:36
An: RPG programming on the IBM i / System i
Betreff: Cursor closed (probably by commit or rollback)

Hi,

I've got a SQLRPG (OPM) program that do the following :

declare cursor
open cursor
//loop
fetch
call pgm2 (under some circumstances)
//endloop
close cursor

After each time pgm2 is executed, my cursor in the calling program is
closed, and I get SQL0501 in my fetch.
Note that pgm2 ends with either COMMIT or ROLLBACK

Is there any chance I get my cursor in the main program not closed by the
call of pgm2?

None of my programs are in ILE.

Thanks in advance.

--
Mahefa

"La razon es tediosa y aburrida...*utilizaremos la fuerza*"
(Los Pinguinos de Madagascar)