17.10 - 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
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
Language
English (United States)

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