16.20 - SQLJ.REMOVE_JAR External Stored Procedure - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Programming Reference
Publication ID
B035-1147-162K
Language
English (United States)

Definition

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';

where:

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);