SCHEMA

Schema-name qualifier of the table or view.

CHAR(18)

NOT NULL

NAME

Name of the table or view.

CHAR(18)

NOT NULL

SEGMENT

Segment that contains the area where table rows are stored.

CHAR(8)

AREA

Area where table rows are stored.

CHAR(18)

TABLEID

Internal record ID of the database record underlying the table.

SMALLINT

NOT NULL

TYPE

Type of table:

• A—View on referencing SQL schema table
• F—Function
• L—Owner of local variables of a routine
• N—Record in a non-SQL-defined schema
• P—Table procedure
• R—Procedure
• T—Base table
• V—View

CHAR(1)

NOT NULL

LOCMODE

Storage location mode for a table:

• C—Clustered
• D—Direct
• H—CALC
• R—Row ID index
• U—Unique calc

Global storage allocation option for a table procedure:

• N—Non-keyed global storage
• K—Keyed global storage

CHAR(1)

NOT NULL

COMPRESS

Compression indicator:

• Y—Compressed
• N—Uncompressed
• P—Compressed with CA IDMS Presspack

For TYPE = R (procedure) or F (function), this is the protocol:

• I—IDMS
• A—ADS

CHAR(1)

NOT NULL

FORMAT

Format of the database record underlying the table:

• F—Fixed length
• V—Variable length

CHAR(1)

NOT NULL

UPDATABLE

When TYPE is V, updatable view indicator:

• Y—Updatable
• N—Not updatable
• Blank—Not known at definition time

CHAR(1)

NOT NULL

CHECKOPT

When TYPE is V, WITH CHECK OPTION indicator:

• Y—View defined with WITH CHECK OPTION
• N—View defined without WITH CHECK OPTION

CHAR(1)

NOT NULL

TIMESTAMP

Table timestamp, used for synchronization with access module definitions,

TIMESTAMP

NOT NULL

CTIME

Date and time when the table or view was created.

TIMESTAMP

NOT NULL

UTIME

Date and time when the table or view was last altered.

TIMESTAMP

NOT NULL

CUSER

ID of the user who created the table or view.

CHAR(18)

NOT NULL

UUSER

ID of the user who last altered the table or view.

CHAR(18)

NOT NULL

PUTROUTINE

• When TYPE = T: CA IDMS Presspack data characteristic table (DCT) name.
• When TYPE = P or R or F: external program or dialog name

CHAR(8)

NOT NULL

GETROUTINE

Reserved for a table.

Global storage key for a procedure.

CHAR(8)

NOT NULL

LENGTH

Internal length of underlying database record, including prefix.

SMALLINT

NOT NULL

DATALENGTH

Internal length of the data portion of the underlying database record (including four-byte RDW for a compressed table).

SMALLINT

NOT NULL

PREFIXLENGTH

Internal length of the prefix portion of the underlying database record for a table.

Length of the local work area for a procedure.

SMALLINT

NOT NULL

CTRLENGTH

Internal length of the control portion (without the prefix) of the underlying database record for a table.

Length of the global work area for a procedure.

SMALLINT

NOT NULL

FIXLENGTH

Internal length of the fixed portion (without the prefix) of the underlying database record.

SMALLINT

NOT NULL

SECLENGTH

Length of the I-tree stored in the associated section table rows, for a view or check constraint.

SMALLINT

NOT NULL

NUMSYNTAX

Number of rows in the syntax table for a view or check constraint.

SMALLINT

NOT NULL

NUMCOLS

Number of columns in the table or view.

SMALLINT

NOT NULL

NUMINDEXES

Number of indexes on the table.

SMALLINT

NOT NULL

NUMREFERENCED

Number of constraints where the table is the referenced table.

SMALLINT

NOT NULL

NUMREFERENCING

Number of constraints where the table is the referencing table.

SMALLINT

NOT NULL

DISPLACEMENT

Displacement, in pages, from cluster index or constraint for a table.

Estimated number of I/Os for a procedure.

INTEGER

NOT NULL

ESTROWS

Estimated number of rows in the table.

INTEGER

NOT NULL

NUMPAGES

Number of pages containing rows of the table when statistics were last updated.

INTEGER

NOT NULL

NUMROWS

Actual number of rows in the table when statistics were last updated.

INTEGER

NOT NULL

ROWSPERPAGE

Number of table rows per page when statistics were last updated.

INTEGER

NOT NULL

AVGROWLENGTH

Average length of a table row when statistics were last updated.

REAL

NOT NULL

PCTSPACEUSED

Percentage of space used in the area where table rows are stored when statistics were last updated.

REAL

NOT NULL

PCTFRAGROWS

Percentage of rows fragmented in storage when statistics were last updated.

REAL

NOT NULL

NUMIO01

Number of IOs required to read all rows with 1 buffer, when statistics were last updated.

REAL

NOT NULL

NUMIO03

Number of IOs required to read all rows with 3 buffers, when statistics were last updated.

REAL

NOT NULL

NUMIO05

Number of IOs required to read all rows with 5 buffers, when statistics were last updated.

REAL

NOT NULL

NUMIO10

Number of IOs required to read all rows with 10 buffers, when statistics were last updated.

REAL

NOT NULL

NUMIO20

Number of IOs required to read all rows with 20 buffers, when statistics were last updated.

REAL

NOT NULL

PROCMODE

Execution mode for a table procedure:

• U—User mode
• S—System mode

CHAR(1)

NOT NULL

TXNSHARNG

Transaction sharing:

• Y—Yes
• N—No
• D—Default

CHAR(1)

NOT NULL

PROCDBNAME

Default Database:

• P—Current
• not P—Null

CHAR(1)

NOT NULL

DEFAULTINDEX

When TYPE is T, Row ID index indicator:

• Y—Yes
• N—No

CHAR(1)

NOT NULL

SECLENGTH2

Length of syntax for views and check constraints.

INTEGER

NOT NULL

LANGUAGE

Language of an SQL-invoked routine.

CHAR3

FILLER3

Reserved for future use.

BINARY(1)

NOT NULL

DYNRESULTSETS

Number of dynamic results sets of an SQL-invoked procedure.

SMALLINT

NOT NULL

FILLER

Reserved for future use.

BINARY(18)

NOT NULL