Re: SQL Question

["Nelson C. Smith" <ncsmith@xxxxxxxx>]

I tried the delay parameter today and it made no difference.  The only thing
that has worked so far is RclActGrp.

-----Original Message-----
From: David Morris <dmorris@plumcreek.com>
To: RPG400-L@midrange.com <RPG400-L@midrange.com>
Date: Monday, August 09, 1999 2:05 PM
Subject: Re: SQL Question


>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
>
>

+---
| 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