RE: Deterministic with an external rpg stored procedure

Paul,
I don't know.
But, if your 2 parameters are never changed,
maybe change and see what happens ?

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of PAPWORTH Paul
Sent: Friday, December 20, 2013 4:53 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: Deterministic with an external rpg stored procedure

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.