After sending this I got my lazy butt over to google to learn that *SYS
naming is not supported for qualified UDF's.
Grrrr...
I also learned that our developer was forward thinking and actually has
the "libraries" property in the JDBC settings, so I just added the
libraries I needed into the JDBC connection info and all is well.
It was a good lesson on SQL UDF's though.
Regards,
Richard Schoen
RJS Software Systems Inc.
"Get the information you need. Now!"
Email: richard@xxxxxxxxxxxxxxx
Web Site:
http://www.rjssoftware.com
Tel: (952) 898-3038
Fax: (952) 898-1781
Toll Free: (888) RJSSOFT
-----Original Message-----
------------------------------
message: 8
date: Sat, 28 Jun 2008 12:07:38 +0000
from: vhamberg@xxxxxxxxxxx
subject: Re: SQL User Defined Function Location - Can it be qualified
of does library need to be in *LIBL ?
Chuck - as far as I have been able to discern, the *SYS naming for
qualifying a UDF looks like division - it fails in the parser, as I
recall. One of those ambiguous patterns the lexer and parser don't know
what to do with - heh!
Vern
midrange.com
