SQL Deterministic UDF and File Read Count

["Bill" <BillZBubb@xxxxxxxxxx>]

I have created an SQL UDF which is specified as Deterministic.  The UDF is
written in RPGLE and accesses a table as part of it's logic.  When I do a
Select statement in SQL and reference the UDF it returns the data as
expected.

The concern I have is regarding the file access count:  it has the same
number of accesses as there are number of records returned -- but the input
parameters to the UDF were the same for each UDF access.

Am I correct that there would be one access to the UDF's table
corresponding to the first "call" and then since each subsequent call has
the same parameter values it shouldn't access the table again?   This is on
a V5R2 system.

Bill