16.20 - SQLJ.REDISTRIBUTE_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.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');