SQLJ System Views | Data Dictionary | Teradata Vantage - 17.00 - SQLJ System Views - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

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