SYSCAT.COLUSE catalog view
Each row represents a column that is referenced in the DIMENSIONS clause of a CREATE TABLE statement.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
TABSCHEMA | VARCHAR (128) | Schema name of the table containing the column. | |
TABNAME | VARCHAR (128) | Unqualified name of the table containing the column. | |
COLNAME | VARCHAR (128) | Name of the column. | |
DIMENSION | SMALLINT | Dimension number, based on the reverse order of dimensions specified in the DIMENSIONS clause (initial position is 1). For a composite dimension, this value will be the same for each component of the dimension. | |
COLSEQ | SMALLINT | Numeric position of the column in the dimension to which it belongs (initial position is 1). The value is 1 for the single column in a noncomposite dimension. | |
TYPE | CHAR (1) | Type of dimension.
|