CREATE/REPLACE PROCEDURE Dictionary Table Actions for Java Procedures | Vantage - 17.10 - CREATE PROCEDURE Dictionary Table Actions for Java Procedures - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
Language
English (United States)

The system performs the following actions on the Java external procedure-specific dictionary tables referenced by the SQLJ database during a CREATE PROCEDURE request.

  1. The uniqueness of the Java procedure to be created is verified based on its name.
  2. The EXTERNAL NAME clause for the Java procedure is then examined to determine the JAR being referenced as its source.

    When the referenced JAR reference has been found, the system searches DBC.Jars for the JAR name specified in the EXTERNAL NAME clause.

  3. The JAR name specified in the EXTERNAL NAME clause must be defined in the database for the CREATE PROCEDURE request to complete successfully.

    If the system does not find the JAR name as an entry in DBC.Jars, the request aborts and returns an error to the requestor.

  4. Once the new Java procedure has been verified, the system adds a row to DBC.Routine_Jar_Usage to indicate that the new Java routine uses the JAR specified in its EXTERNAL NAME clause.