SQLJ.REDISTRIBUTE_JAR External Stored Procedure - Advanced SQL Engine - Teradata Database

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
qwr1571437338192.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata Vantage™

Definition

REPLACE PROCEDURE SQLJ.REDISTRIBUTE_JAR
   (IN jarname VARCHAR(128) CHARACTER SET UNICODE)
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.

Example: SQLJ.REDISTRIBUTE_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 redistribute the registered JAR file:

DATABASE JXSP;
CALL SQLJ.REDISTRIBUTE_JAR('Accounts_JAR');