16.20 - SYSLIB Tables - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Programming Reference
Publication ID
B035-1147-162K
Language
English (United States)

The following table identifies the column names and contents of the dem, demddl, and dempart FALLBACK protected tables in the SYSLIB database.

Table Name and Description Column and Type Column Description
SYSLIB.dem

Stores the currently installed version of packages.

The loadpkg stored procedure populates this table when you restore a specific version of a package to a target database.

name VARCHAR(30) Name of the package.
version VARCHAR(30) Version of the currently installed package.
dbase VARCHAR(30) Database in which the package is installed.
itime TIMESTAMP(6) Date of the installation.
SYSLIB.demddl

Stores the CREATE/REPLACE DDL information of all packages.

name VARCHAR(30) Name of the package associated with the DDL statements.

This is the value of the U_Name argument in a call to savepkg stored procedure.

version VARCHAR(30) Version of the package associated with the DDL statements.

This is the value of the U_Version argument in a call to savepkg stored procedure.

dbase VARCHAR(30) Target database of the package installation.

This is the value of the U_Database argument in a call to savepkg stored procedure.

ddlcontent CLOB(2097088000) CREATE/REPLACE statement for installing the package identified by the name and version columns.

This is the value of the U_Create argument in a call to savepkg stored procedure.

demtype VARCHAR(5) Type of package or package component that the CREATE/REPLACE statement creates.

This is the value of the U_DemT argument in a call to savepkg stored procedure.

itime TIMESTAMP(6) Date when the DDL information was saved.
SYSLIB.dempart

Stores each part of a package.

For example, a part could be in source, object, or library format.

name VARCHAR(30) Name of the package associated with the part.

This is the value of the U_Name argument in a call to savepkg stored procedure.

version VARCHAR(30) Version of the package associated with the part.

This is the value of the U_Version argument in a call to savepkg stored procedure.

dbase VARCHAR(30) Target database of the package installation.

This is the value of the U_Database argument in a call to savepkg stored procedure.

partfn VARCHAR(30) Filename of the package.

This is the value of the U_DemFN argument in a call to savepkg stored procedure.

partcontent BLOB(2097088000) Package content.

This is the value of the U_Content argument in a call to savepkg stored procedure.