I have an external java stored proc and is working fine if I put the class
file in sqllib\function directory.
If I want to put the class file in a directory other than sqllib\function,
how do I do that ? I tried setting
the CLASSPATH varaibale in db2cshrc of Instance owner id, fence id but
nothing seems to be working.
Is there any registry variable that I need to set ?
(Linux DB2 8.1 FP 2)

Thanks

Dave <adavi@comcast.net> wrote:
[color=blue]
> I have an external java stored proc and is working fine if I put the
> class
> file in sqllib\function directory.
> If I want to put the class file in a directory other than
> sqllib\function, how do I do that ? I tried setting
> the CLASSPATH varaibale in db2cshrc of Instance owner id, fence id but
> nothing seems to be working.
> Is there any registry variable that I need to set ?
> (Linux DB2 8.1 FP 2)[/color]

Have a look at the CREATE FUNCTION statement and in particular the
requirements on the EXTERNAL NAME clause. There you can specify the
location for the class file that should be loaded, including the path where
DB2 ought to look for it.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena

Dave <adavi@comcast.net> wrote:
[color=blue]
> I have an external java stored proc and is working fine if I put the
> class
> file in sqllib\function directory.
> If I want to put the class file in a directory other than
> sqllib\function, how do I do that ? I tried setting
> the CLASSPATH varaibale in db2cshrc of Instance owner id, fence id but
> nothing seems to be working.
> Is there any registry variable that I need to set ?
> (Linux DB2 8.1 FP 2)[/color]

Have a look at the CREATE FUNCTION statement and in particular the
requirements on the EXTERNAL NAME clause. There you can specify the
location for the class file that should be loaded, including the path where
DB2 ought to look for it.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena