RE: Is SQL cursor open at the job level?

OR....

Compile to CLOSQLCSR(*ENDMOD) 

Or...

c/exec sql
C+ SET OPTION CLOSQLCSR=*ENDMOD
c/end-exec 


Thanks,
Tommy Holden


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
Michael_Schutte@xxxxxxxxxxxx
Sent: Wednesday, April 12, 2006 1:44 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Is SQL cursor open at the job level?

Is this a SQL Procedure or RPG Procedure using SQL?

If RPG, add the HSPEC

H ActGrp(*NEW)... I believe?

Michael Schutte
Work 614-492-7419
email  michael_schutte@xxxxxxxxxxxx


 

             "Lim Hock-Chai"

             <Lim.Hock-Chai@us

             amobility.com>
To 
             Sent by:                  "RPG programming on the AS400 /

             rpg400-l-bounces@         iSeries" <rpg400-l@xxxxxxxxxxxx>

             midrange.com
cc 
 

 
Subject 
             04/12/2006 02:40          Is SQL cursor open at the job

             PM                        level?

 

 

             Please respond to

              RPG programming

              on the AS400 /

                  iSeries

             <rpg400-l@midrang

                  e.com>

 

 





I need to do recursive call on a procedure that declare and open sql
cursor.  I'm getting a cursor already open error when recursively
calling the procedure.  Is there a way a go around that?


--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.