REPLACE PROCEDURE Dictionary Table Actions for Java Procedures - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™

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

  1. The uniqueness of the Java procedure to be replaced 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 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 REPLACE 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 takes 1 of 2 possible paths, depending on whether the named procedure is new or already exists.
    IF the procedure … THEN the system …
    is new adds a row to DBC.Routine_Jar_Usage to indicate that the new Java routine uses the JAR specified in its EXTERNAL NAME clause.
    already exists updates the row in DBC.Routine_Jar_Usage to indicate that the replacement Java routine uses the JAR specified in its EXTERNAL NAME clause.