Re: SQL UDF

thanks Bill.

Wes
"Bill" <brobins3d@xxxxxxxxx> wrote in message
news:06c001c5d680$984c1c90$fe0064c8@xxxxxxxxxxxxx
> Wes wrote:
> > Hi List,
> >
> > I have a function that will always return the same result if the input
> > criteria is the same. After running it and noticing the IO for that
> > file was too high, I changed the function to deterministic, hoping it
> > would cache the result after the first call. That doesn't seem to be
> > the case...
>
> Wes,
>
> I had the same question a couple of months ago, look at Elvis' reply here:
> http://archive.midrange.com/midrange-l/200502/msg00721.html
>
> Funny thing is, I think I was going over the same table as you are, but I
> was using an RPGLE module instead of SQL for the function.
>
> Bill
>
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email:
MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>