JAR_JAR_USAGE - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

The JAR_JAR_USAGE view identifies each JAR owned by a given user or database on which other JARs defined on the system are dependent.

View Column Name Description Data Type Format
DatabaseId The identifier of the database or user in which the JAR identified by JarName is defined. BYTE(4)

NOT NULL

X(8)
JarName The name designator for a JAR that depends on code from another JAR.
  • VARCHAR(128)
  • UNICODE
  • UPPERCASE
  • NOT CASESPECIFIC
  • NOT NULL
X(128)
PathJarName The name designator for a JAR, which is in the SQL-Java path of the JAR identified by JarName.

The SQL-Java path is the search path defined for a particular JAR. With a SQL-Java path defined, a method defined in a particular JAR (JAR A) may invoke a method which is defined in another JAR (JAR B), if JAR B (and all its classes) is contained in the SQL-Java path of JAR A. A SQL-Java path for a JAR can only be created, altered, or dropped via a call to SQLJ.Alter_Java_Path.

  • VARCHAR(128)
  • UNICODE
  • UPPERCASE
  • NOT CASESPECIFIC
  • NOT NULL
X(128)