SQLJ.REMOVE_JAR

The SQLJ.REMOVE_JAR system procedure removes an installed JAR file from SQLFire.

Syntax

SQLJ.REMOVE_JAR(IN QUALIFIED_JAR_NAME VARCHAR(32672),
                IN UNDEPLOY INTEGER)
QUALIFIED_JAR_NAME
The SQLFire name of the JAR file, qualified by the schema name. (This should correspond to the name that you specified in the SQLJ.INSTALL_JAR command.) Two examples:
MYSCHEMA.Sample1
 -- a delimited identifier.
MYSCHEMA."Sample2"
UNDEPLOY
This integer argument is used to specify an alias for the JAR file. However, SQLFire ignores this argument, so it is normally set to 0.

Example

-- SQL statement
CALL SQLJ.REMOVE_JAR('APP.Sample1', 0)

SQLFire unloads the JAR file classes that were installed using the name "APP.Sample1."