ALLBASE/SQL Reference Manual (36216-90216)

106 Chapter2
Using ALLBASE/SQL
Understanding the System Catalog
definitions are stored in the system catalog. As database activities occur, most of the
information in the catalog is updated automatically, so the system catalog provides an
up-to-date source of information on a DBEnvironment.
Immediately following an UPDATE STATISTICS statement, the views in the system catalog,
summarized in Table 2-2, are a source of up-to-date information on a DBEnvironment and
the structure and use of its databases. Refer to the ALLBASE/SQL Database
Administration Guide for additional information on the system catalog.
Table 2-2. System Views
View Name Purpose
SYSTEM.ACCOUNT Identifies the I/O usage of current database sessions.
SYSTEM.CALL Identifies current internal calls.
SYSTEM.CHECKDEF Contains the search condition defined for each table check
constraint. Contains the column name for each column check
constraint.
SYSTEM.COLAUTH Identifies users and groups and their column update and
reference authorities.
SYSTEM.COLDEFAULT Describes the default value of each column defined with a
non-NULL default.
SYSTEM.COLUMN Contains the definition of each column in each table and view.
SYSTEM.CONSTRAINT Contains information on integrity constraints.
SYSTEM.CONSTRAINTCOL Contains information on the columns within unique and
referential constraints.
SYSTEM.CONSTRAINTINDEX Describes each unique and referential constraint index.
SYSTEM.COUNTER Describes the status of internal system counters.
SYSTEM.DBEFILE Describes the characteristics of each DBEFile.
SYSTEM.DBEFILESET Describes the characteristics of each DBEFileset.
SYSTEM.GROUP Describes each authorization group.
SYSTEM.HASH Describes each hash structure.
SYSTEM.IMAGEKEY Describes each Master and Detail Dataset key associated with
TurboIMAGE databases attached to the DBE.
SYSTEM.INDEX Describes each index.
SYSTEM.INSTALLAUTH Identifies users and authorization groups that have been granted
INSTALL authority.
SYSTEM.MODAUTH Identifies users and groups and the programs they can run.
SYSTEM.PARAMDEFAULT Describes the default value of each parameter defined with a
non-NULL default.
SYSTEM.PARAMETER Describes each parameter of each procedure.