SYSCAT.INDEXEXTENSIONPARMS catalog view
Each row represents an index extension instance parameter or source key column.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
IESCHEMA | VARCHAR (128) | Schema name of the index extension. | |
IENAME | VARCHAR (128) | Unqualified name of the index extension. | |
ORDINAL | SMALLINT | Sequence number of the parameter or key column. | |
PARMNAME | VARCHAR (128) | Name of the parameter or key column. | |
TYPESCHEMA | VARCHAR (128) | Schema name of the data type of the parameter or key column. | |
TYPENAME | VARCHAR (128) | Unqualified name of the data type of the parameter or key column. | |
LENGTH | INTEGER | Data type length of the parameter or key column. | |
SCALE | SMALLINT | Data type scale of the parameter or key column; 0 if not applicable. | |
PARMTYPE | CHAR (1) |
|
|
CODEPAGE | SMALLINT | Code page of the index extension instance parameter; 0 if not a string type. | |
COLLATIONSCHEMA | VARCHAR (128) | Y | For string types, the schema name of the collation for the parameter; the null value otherwise. |
COLLATIONNAME | VARCHAR (128) | Y | For string types, the unqualified name of the collation for the parameter; the null value otherwise. |