This screen lists information about indexes, referential constraints, and hash structures for each table contained in a DBEFileSet.
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.
Printable version
