CODEWITHSUNDEEP
db2java-stored-procedures
binary_assemble
binary_assemble

Reputation: 432

How to drop DB2 Java Stored Procedure?

I have deployed a Java Stored Procedure through IBM Data Studio, and now I want to undeploy it, but I don't know how to do it completely.

I know you have to drop the procedure by calling DROP PROCEDURE <procedure name>.

Delete the record from SYSIBM.SYSJAVAOPTS that has my JAR_ID.

But how do you undeploy what SQLJ.DB2_INSTALL_JAR did?

It must have register my JAR file somewhere on DB2 because the first parameter is a BLOB of the JAR.

Upvotes: 0

Views: 269

Answers (1)

Mark Barinstein
Mark Barinstein

Reputation: 12299

This can be done with the call sqlj.remove_jar( jar-id ) statement as described in JAR file administration on the database server.

Upvotes: 1

Related Questions