SQLJ.REMOVE_JAR External Stored Procedure - Analytics Database - Teradata Vantage

Syntax

REPLACE PROCEDURE SQLJ.REMOVE_JAR
   (IN jarname VARCHAR(128) CHARACTER SET UNICODE,
    IN undeploy  INTEGER )
LANGUAGE C
NO SQL
PARAMETER STYLE SQL
EXTERNAL NAME 'SL!xsplib';

Syntax Elements

jarname

SQL identifier that was passed to SQLJ.INSTALL_JAR, enclosed in apostrophes.

undeploy

Integer value reserved for future use.

For now, the value of undeploy must be zero.

Example: SQLJ.REMOVE_JAR External Stored Procedure

Consider a JAR file that was registered with the JXSP database using the following statements:

DATABASE JXSP;
CALL SQLJ.INSTALL_JAR('SJ!java_xsp/accounts.jar', 'Accounts_JAR', 0);

The following statements remove the registered JAR file:

DATABASE JXSP;
CALL SQLJ.REMOVE_JAR('Accounts_JAR', 0);