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. |