Re: SQL optimization in bound procedures similar to LR OFF

On the CRTRPGSQLI is a parameter for when to close cursors. If it is set to
*ACTGRP, the system does not close cursor until the activation group is
closed. If you set it Module, it close when the module closes.

Also, you are not saying how this bound procedure gets called. In a service
program, just a procedure in a program? If you have things that you do not
want to close out, put them in global memory. More information needed.


On Wed, Aug 13, 2014 at 4:26 PM, Brad Sommerfeld <brads@xxxxxxxxxxxxxxxxx>
wrote:

In a program, I can return without setting on LR and the file opens,
variables etc. do not close or get cleared. This saves me the time of
opening them on the next call for programs that are called frequently with
significant initialization cost.

My question is how to achieve the same effect when I have a procedure in a
module that uses SQL? I would like a 2nd and following call to be able to
use the new values passed in with the existing SQL statement and cursor. I
call the procedure 12 times in a row from another program and it is taking
up to 1 second per call.

If there is a keyword that will help me find this on the web, please let
me know because all of my searching has not yielded the answer.


--
This is the RPG programming on the IBM i (AS/400 and 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.