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

Syntax

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

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