DB2 Version 9.7 for Linux, UNIX, and Windows
DB2 Version 9.7 for Linux, UNIX, and Windows
Each row represents a search method. An index extension can contain more than one search method.
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| METHODNAME | VARCHAR (128) | Name of the search method. | |
| METHODID | SMALLINT | Number of the method in the index extension. | |
| IESCHEMA | VARCHAR (128) | Schema name of the index extension on which this method is defined. | |
| IENAME | VARCHAR (128) | Unqualified name of the index extension on which this method is defined. | |
| RANGEFUNCSCHEMA | VARCHAR (128) | Schema name of the range-through function. | |
| RANGEFUNCNAME | VARCHAR (128) | Unqualified name of the range-through function. | |
| RANGESPECIFICNAME | VARCHAR (128) | Function-specific name of the range-through function. | |
| FILTERFUNCSCHEMA | VARCHAR (128) | Y | Schema name of the filter function. |
| FILTERFUNCNAME | VARCHAR (128) | Y | Unqualified name of the filter function. |
| FILTERSPECIFICNAME | VARCHAR (128) | Y | Function-specific name of the filter function. |
| REMARKS | VARCHAR (254) | Y | User-provided comments, or the null value. |