Re: SQLRPGLE CLOSE question

[rob@xxxxxxxxx]

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Can you move your close to the bottom of the loop?

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




dmosley@dancik.com
Sent by: rpg400-l-admin@midrange.com
05/31/2002 03:24 PM
Please respond to rpg400-l


        To:     rpg400-l@midrange.com
        cc:
        Fax to:
        Subject:        Re: SQLRPGLE   CLOSE question



Well, I figured that.  Then, let me ask you this.  Don't I need to close
the cursor, when I want to perform a another, or should I say, different
PREPARE statement.

Here's what I am doing...

 First Pass :  CLOSE CURSOR  (Job Log message is written...)
          PREPARE (SELECT *.......)
          OPEN
          FETCH

Second Pass :  (My SELECT has now been changed.
          CLOSE CURSOR
          PREPARE (New SELECT *.....)
          OPEN
          FETCH


Don't I need to close the Cursor before my second pass of the PREPARE?
I suppose I could place the CLOSE around an IF-statement.  I wasn't sure
if
the was a different way..

thanks
dav


David L. Mosley, Jr.
Systems Analyst
2000 CentreGreen Way
Suite 250
Cary, NC 27513



                    rob@dekko.com
                    Sent by:                 To:     rpg400-l@midrange.com
                    rpg400-l-admin@mi        cc:
                    drange.com               Subject:     Re: SQLRPGLE
CLOSE question


                    05/31/02 04:19 PM
                    Please respond to
                    rpg400-l






This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Don't try to close cursors which are not opened?

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




dmosley@dancik.com
Sent by: rpg400-l-admin@midrange.com
05/31/2002 03:13 PM
Please respond to rpg400-l


        To:     rpg400-l@midrange.com
        cc:
        Fax to:
        Subject:        SQLRPGLE   CLOSE question


Is there a way to avoid having the "Cursor [Cursor Name] not open."
message
from being written to the joblog, whenever I do a CLOSE, in SQL.

C/exec sql
C+    close dyn@cursor
C/end-exec

Thanks
dav

David L. Mosley, Jr.
Systems Analyst
2000 CentreGreen Way
Suite 250
Cary, NC 27513

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



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




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