SQLJ.REMOVE_JAR

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

Syntax

SQLJ.REMOVE_JAR(IN QUALIFIED_JAR_NAME VARCHAR(32672),
                IN UNDEPLOY INTEGER)
QUALIFIED_JAR_NAME
The GemFire XD 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, GemFire XD ignores this argument, so it is normally set to 0.

Example

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

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