Column name
|
Data type
|
Description
|
TABLE_SYSID
|
INTEGER
|
System identifier of the table or view. |
TABLE_TYPE
|
CHAR(20)
|
One of:
"BASE TABLE"
"VIEW". |
TABLE_NOCOLS
|
INTEGER
|
Number of columns in table. |
TABLE_RECLEN
|
INTEGER
|
Record length for table. |
TABLE_CARD
|
BIGINT
|
Number of records in table. |
STATISTIC_GATHERED
|
TIMESTAMP(2)
|
Date and time when statistics for the table or view were lasted updated. |
IS_LEVEL2_APPROVED
|
CHAR(3)
|
One of:
"NO" = The table can not be used with level 2 DB interface. |
IS_PERSISTENT
|
CHAR(3)
|
One of:
"NO" = The table is a temporary table
"YES" = The table is not temporary. |
DATABANK_SYSID
|
INTEGER
|
System identifier of the databank in which the table is stored. |
