Deterministic with an external rpg stored procedure -- RPG400-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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 mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.