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

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.