Full path in EXTERNAL NAME on Windows?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Larry Menard - 23 Nov 2005 05:49 GMT

I'm trying to catalog a java UDF, and do it as simply as possible.

The UDF is in "c:\temp\myudf.class", and I would prefer to not have to copy the file into "sqllib\function". But I'm unable to fet the CREATE FUNCTION statement to work. Any time the path to the library includes a colon (':'), it seems to be interpreting it as a jar file id. The error returned is:

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL20204N The user defined function or procedure "LMENARD.PATH_UDF" was
unable to map to a single Java method. LINE NUMBER=3. SQLSTATE=46008

So how does one specify an absolute path in an EXTERNAL NAME clause on Windows?

Signature

--------------------
Larry Menard
"Defender of Geese and of All Things Natural"

Reply to this Message

4.spam@mail.ru - 23 Nov 2005 15:30 GMT

Hello.

> So how does one specify an absolute path in an EXTERNAL NAME clause on Windows?

You have to copy your file into sqllib\function.
Why don't you want to do this?

Sincerely,
Mark B.

Reply to this Message

Larry Menard - 23 Nov 2005 15:40 GMT

> Why don't you want to do this?

Because it's easier not to. ;-) The application developers of the
application I'm porting would much rather keep the class file in their own
product directory and catalog it as such.

> You have to copy your file into sqllib\function.

I disagree with that. The docs clearly say you can put the file anywhere
and point the UDF to it. But they conveniently give examples only of
Unix/Linux paths, where there are no colons to deal with.

Signature

--------------------
Larry Menard
"Defender of Geese and of All Things Natural"

> Hello.
>
[quoted text clipped - 6 lines]
> Sincerely,
> Mark B.

Reply to this Message