question about java routines

[situ]

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

[Phil Sherman]

Re: question about java routines

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


situ wrote:

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
>