DB2 Java user defined function

Question

I'm trying to write a Java function for my DB2 database. When my class is in SQLLIB/Function all is working great. Now i need to change the path of the class to another location for client deployment. I can't seem to make it work.

Please Help!

Thanks.

Ben · Accepted Answer · 2010-01-31 15:24:13Z

2

you have to register your jar file with the database with 'SQLJ.INSTALL_JAR'.

CALL SQLJ.INSTALL_JAR('file:/home/db2inst/classes/Proc.jar' , 'myproc_jar', 0)

see: http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/rzaha/writeudf.htm

answered Jan 31, 2010 at 15:24

Ben

4722 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

DB2 Java user defined function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related