Re: SQL Question

["David Morris" <dmorris@xxxxxxxxxxxxx>]

Nelson,

I encountered same several years ago.  I found that changing the delay 
prepare parameter to *YES fixed the problem.  I tried to report this to IBM 
service.  They couldn't see that this was a problem and kept telling me 
how a prepare should be used.  Our conversations kept going in circles 
and I finally gave up.  This was about six years ago.  I finally gave up.

I don't know if this is still a problem because I automatically use delay 
prepare now, but it is worth a try.

David Morris


>>> "Nelson C. Smith" <ncsmith@gate.net> 08/08/99 12:38PM >>>
What is the proper SQL way to close a file (or an ODP) that has been opened
with a Prepare, Declare Cursor, Open Cursor, Fetch, Close Cursor series of
statements?  As I understand it, the close cursor statement doesn't close
the file, thereby eliminating a lot of overhead on subsequent open cursors.
This is good, but sometimes you might really need to close the file
altogether.  I don't see any kind of SQL statement to do that.

This is generic copy code used in procedures in service programs and even
though the cursor is closed and the procedure goes away, the service program
persists and I am having problems getting rid of the old ODP when I need to
change the keys in the Select Statement.  Blowing away the service program
between calls with a RclActGrp command does fix the problem, but is somewhat
of a sledge-hammer method when I would like to have something a little more
precise.  I would like to just close whatever the Declare established and
not have the overhead of reinitializing the service program each time.

A new Prepare and Declare doesn't seem to do it.  I get no data returned on
the subsequent calls even though a message is returned saying "1 rows
returned" and no error codes of any kind.  Apparently, it is trying to still
use the ODP established by the first Prepare and Declare.  Any suggestions?


+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---END