question about java routines

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

situ - 27 Oct 2006 09:05 GMT

hi,

is it necessary to put jar file or class file inside a
$DB2INSTANCE/sqllib/function directory .

i appended my own customised path to the existing CLASSPATH variable
but its giving SQL4304N.

does DB2 support this.

i am using DB2 v8.1.7.445", "s040812", "WR21342", and FixPak 7

thanks
sri

Reply to this Message

Phil Sherman - 27 Oct 2006 17:09 GMT

It depends on who will execute the routine. If it's the database manager
(ie. a function), then you must place it in a location that the database
manager will look for it - the function directory. If you are executing
the code, then it must be in a location from which the Java executable
can load it - CLASSPATH.

Phil Sherman

> hi,
>
[quoted text clipped - 10 lines]
> thanks
> sri

Reply to this Message