Contains one row for each column for which statistics can be
updated. Statistics are not recorded for inherited columns of typed
tables.
Table 104. SYSSTAT.COLUMNS Catalog View
| Column Name | Data Type | Nullable | Description | Updatable |
|---|---|---|---|---|
| TABSCHEMA | VARCHAR(128) |
| Qualified name of the table that contains the column. |
|
| TABNAME | VARCHAR(128) |
|
| |
| COLNAME | VARCHAR(128) |
| Column name. |
|
| COLCARD | BIGINT |
| Number of distinct values in the column; -1 if statistics are
not gathered; -2 for inherited columns and columns of
H-tables.
For any column, COLCARD cannot have a value higher than the cardinality of the table containing that column. This column can only be updated with the following values:
| Yes |
| HIGH2KEY | VARCHAR(33) | Yes | Second highest value of the column. This field is empty if
statistics are not gathered and for inherited columns and columns of
H-tables.
This column can be updated with a valid representation of the value appropriate to the column that the statistic is associated with. LOWKEY2 should not be greater than HIGH2KEY. | Yes |
| LOW2KEY | VARCHAR(33) | Yes | Second lowest value of the column. Empty if statistics not
gathered and for inherited columns and columns of H-tables.
This column can be updated with a valid representation of the value appropriate to the column that the statistic is associated with. | Yes |
| AVGCOLLEN | INTEGER |
| Average column length. -1 if a long field or LOB, or
statistics have not been collected; -2 for inherited columns and
columns of H-tables.
This column can only be updated with the following values:
| Yes |
| NUMNULLS | BIGINT |
| Contains the number of nulls in a column. -1 if statistics
are not gathered.
This column can only be updated with the following values:
| Yes |