Re: SQL Functions

I think your question is, if each of those functions does a
Select ... 
 from IIM
 into :ReturnVar
 where iprod=:item#
and you call all three will it end up doing three i/o's or just one?

I would hope it would all be buffered.  But, honestly, that's just a wag.

Perhaps there's some game you could play with your service program that 
would only actually 'get' the row on the first function that is executed. 
Then the other functions/subprocedures would somehow know that the ITEM# 
is not changed and would thus use some global variable or other technique 
to return the new value requested without an I/O.  Sort of like the getter 
and setter techniques.

Rob Berendt