ROUTINE_JAR_USAGE View | Data Dictionary | Teradata Vantage - ROUTINE_JAR_USAGE - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
prb1610499325399.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

The ROUTINE_JAR_USAGE view identifies the JARs owned by a given user or database on which external Java routines 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)
RoutineName The name designator for a Java external stored procedure that depends on the JAR identified by JarName.
  • VARCHAR(128)
  • UNICODE
  • UPPERCASE
  • NOT CASESPECIFIC
  • NOT NULL
X(128)
JarName The name designator for a JAR that contains code that the RoutineName external stored procedure depends on.
  • VARCHAR(128)
  • UNICODE
  • UPPERCASE
  • NOT CASESPECIFIC
  • NOT NULL
X(128)
Signature The signature defined for Java external stored procedure identified by RoutineName.
  • VARCHAR(6400)
  • LATIN
  • CASESPECIFIC
X(255)