Re: Deterministic with an external rpg stored procedure

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Deterministic means the system doesn't have to call the function if it's
already seen the same parms.

It is not a guarantee that it won't decide to. :)

Also note that "hardly ever changes" isn't the right place to use
deterministic.  Nor is a function with either "READS SQL DATA" or "MODIFIES
SQL DATA".  As anything accessing a table by definition is NOT
DETERMINISTIC.

Charles



On Fri, Dec 20, 2013 at 6:52 AM, PAPWORTH Paul <Paul.PAPWORTH@xxxxxxxx>wrote:

> I'm trying to use deterministic with an external stored procedure
> written in RPG in order to optimize the processing time. The info
> returned by the procedure hardly ever changes .
>
> According to what I understand  deterministic specifies whether or not
> the procedure will always return the same result from repeated calls
> containing the same input values. If the answer is yes, DB2 will cache
> the results and the next time a call is made using the same input
> parameters, the result will be returned to the caller without the
> external program ever being called. Testing under version 7 using the I
> Series Navigateur I notice that the programme seems to be called with
> each request even though the input parameters have not changed. I have
> my 2 parameters declared as Input/Output. Could this be the problem. ?
>
>
>
> CREATE PROCEDURE ITG849/RXL020G(
>
> INOUT  IO_DRXL020  CHAR    (49)    ,
>
> INOUT  IO_DRXCPA   CHAR    (287) )
>
> LANGUAGE RPG     DETERMINISTIC
>
> EXTERNAL NAME    RXL020G
>
> PARAMETER STYLE GENERAL
>
>
>
> Thanks in anticipation
>
> --
> 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.