× 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.


  1.  Home
  2. MIDRANGE-L
  3. September 2012

Re: Almost a year and a half ago, I did some work with SQL UDFs. I'vesince forgotten some crucial things.

Interesting that this paper by Kent shows an couple of examples of a
function reading a table that I'd call NOT DETERMINISTIC but that Kent
has used DETERMINISTIC on...

http://www-03.ibm.com/systems/resources/systems_i_software_db2_pdf_ExternalUDTF.pdf

Charles

On Thu, Sep 6, 2012 at 8:51 AM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:
Given the original description of the UDF, I'd consider it NOT DETERMINISTIC.

I used to use DETERMINISTIC as more of an "it's ok to cache this", but
after discussions with Kent...I quit doing so. Now the only thing I
use DETERMINISTIC on are functions that just look at the input
parameters; date conversion for example.

If James really wants to define this as DETERMINISTIC, I'd suggest
passing in the user ID as well...but I'd guess that he's also looking
at a DB table or something....which in my book automatically makes it
NOT DETERMINISTIC.

Charles

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.