Registering the JAR or ZIP File | Java UDFs | Teradata Vantage - 17.10 - Registering the JAR or ZIP File - 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)

After you write and test the Java source code for a UDF, you place the resulting class or classes in an archive (JAR or ZIP) file.

Next, you call the SQLJ.INSTALL_JAR external stored procedure to register the archive file and its classes with the database, specifying an SQL identifier for the archive file.

If your source code is on a client system, the SQL identifier that you specify is the same name that you use later in the EXTERNAL NAME clause of the CREATE FUNCTION or REPLACE FUNCTION statement to define the SQL function.

For example, consider a JAR file called reports.jar on a Windows client in the directory C:\java_udf.

The following statements register the JAR file with the JUDF database and create an SQL identifier called Report_JAR for the JAR file:

DATABASE JUDF;
CALL SQLJ.INSTALL_JAR('CJ?C:\java_udf\reports.jar', 'Report_JAR', 0);

For more information on how to register archive files for a Java external routine, see Registering and Distributing JAR and ZIP Files for Java External Routines.