|
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.