SQLJ System Views | Data Dictionary | Teradata Vantage - 17.10 - SQLJ System Views - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

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

The SQLJ database and its views are used by the system to manage JAR files that implement Java external stored procedures.

The SQLJ database and its components are created via a DIP script called DIPSQLJ. The DIPSQLJ script is run as part of DIPALL and follows the pattern set by the DBC Data Dictionary initialization process. The DIPSQLJ script revokes all privileges, which could result in modification of SQLJ database views and external stored procedures.

The SQLJ database requires sufficient space for all required components to be defined within it, and the initial space allocation for this database is determined based upon that fact. The best practice is to avoid the placement of additional items into this database, as the SQLJ database could be considered an extension to the Vantage Data Dictionary defined in the DBC database.

The SQLJ system database contains the views:
  • JAR_JAR_USAGE
  • JARS
  • ROUTINE_JAR_USAGE