Each row represents an index extension instance parameter or source key
definition.
Table 112. OBJCAT.INDEXEXTENSIONPARMS Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| IESCHEMA | VARCHAR(128) |
| Qualified name of index extension. |
| IENAME | VARCHAR(18) |
| |
| ORDINAL | SMALLINT |
| Sequence number of parameter or source key. |
| PARMNAME | VARCHAR(18) |
| Name of parameter or source key. |
| TYPESCHEMA | VARCHAR(128) |
| Qualified name of the instance parameter or souce key data type. |
| TYPENAME | VARCHAR(18) |
| |
| LENGTH | INTEGER |
| Length of the instance parameter or source key data type. |
| SCALE | SMALLINT |
| Scale of the instance parameter or source key data type. Zero (0) when not applicable. |
| PARMTYPE | CHAR(1) |
| Type represented by the row:
|
| CODEPAGE | SMALLINT |
| Codepage of the index extension parameter. Zero if not a string type. |