CODEWITHSUNDEEP
stored-proceduresdb2
Db2Cramp
Db2Cramp

Reputation: 33

Running SQLJ procedure on third party tool

How can we execute call sqlj.install_jar('jarpath','jarname','0'); procedure on third party java tools?

I am trying to run this procedure on DBeaver to install the jar file.

But error I am getting:

  • No authorized routine named "SQLJ.INSTALL_JAR" of type "PROCEDURE" having compatible arguments was found.. SQLCODE=-440, SQLSTATE=42884

Is it possible to execute the sqlj commands on third party tool?

I used to install it by logging into Db2 server and execute the command.

Upvotes: 0

Views: 184

Answers (1)

Mark Barinstein
Mark Barinstein

Reputation: 12314

There is no such a routine with 3 parameters indeed. Refer to the following link:
JAR file administration on the database server.

CALL sqlj.install_jar('file:/home/bob/bobsjar.jar', 'MYJAR')

Jar file must be accessible from the database server by the full path provided with the 1-st parameter.

Upvotes: 0

Related Questions