This screen lists information about
indexes, referential constraints, and hash structures for each
table contained in a
DBEFileSet.
![[static]](img/static.gif)
To invoke the Static screen, use the st command
from the Static subsystem or the /st command from
other subsystems.
Field Definitions |
 |
- DBEFILESET
The name of the DBEFileSet.
- HASH?
An asterisk in this field indicates a hashed table.
A table is hashed if the UNIQUE HASH ON or HASH ON CONSTRAINT
clauses are included in the CREATE TABLE statement.
- IMAGE?
An asterisk in this field indicates that
the table is stored in a TurboIMAGE data set instead of
in ALLBASE/SQL DBEFileSets.
- NUMIDX
The number of indexes and referential constraints
defined on the table.
- TYPE
The table type, as defined by the CREATE TABLE statement.
You can use the ALTER TABLE statement to change the table type.
- OWNER.TABLE
The names of the tables contained within the DBEFileSet.
Long column data is stored in internal ALLBASE/SQL tables which
have no entries in SYSTEM.TABLE.
To construct a name for these tables,
SQLMON appends the column number of the long column to the table name.
For example, the PURCHDB.REPORTS(3) entry represents the table that holds
the long column data of the third column of the PURCHDB.REPORTS table.
