ALLBASE/SQL Reference Manual (36216-90216)

Chapter 2 107
Using ALLBASE/SQL
Understanding the System Catalog
SYSTEM.PARTITION Contains partition information.
SYSTEM.PLAN Stores the result of one GENPLAN for each session.
SYSTEM.PROCAUTH Identifies users and groups and the procedures they can execute.
SYSTEM.PROCEDURE Describes each procedure.
SYSTEM.PROCEDUREDEF Contains the definition of each procedure.
SYSTEM.PROCRESULT Describes procedure result columns.
SYSTEM.RULE Describes each rule.
SYSTEM.RULECOLUMN Describes columns an update rule checks for.
SYSTEM.RULEDEF Contains the referencing, WHERE, and EXECUTE PROCEDURE
clause of each rule.
SYSTEM.SECTION Describes stored modules and views.
SYSTEM.SETOPTINFO Contains SETOPT settings for optimizing specific stored sections.
SYSTEM.SPACEAUTH Identifies users and groups and what DBEFileSets they can use
when creating tables, or stored sections.
SYSTEM.SPACEDEFAULT Identifies the default DBEFileSet to use for a new table or stored
section.
SYSTEM.SPECAUTH Identifies users and groups who have special authorities.
SYSTEM.TABAUTH Identifies users and groups and table/view operations they can
perform.
SYSTEM.TABLE Contains a description of each table and view in the
DBEnvironment, including size, owner, and associated
DBEFileSet.
SYSTEM.TEMPSPACE Defines the TempSpace locations.
SYSTEM.TPINDEX Describes third-party indexes used in TurboIMAGE databases
attached to the DBE.
SYSTEM.TRANSACTION Identifies transactions.
SYSTEM.USER Identifies users currently using the database.
SYSTEM.VIEWDEF Contains the SELECT statement that created each view defined in
the system.
Table 2-2. System Views
View Name Purpose