QSYS2.SYSTEXTCONFIGURATION administration table
You can see the configuration parameters for the text search index, as passed by the SYSPROC.SYSTS_CREATE stored procedure, in the QSYS2.SYSTEXTCONFIGURATION administration table.
The following table shows the contents of the QSYS2.SYSTEXTCONFIGURATION administration table. The primary key is the INDEXID column with the PARAMETER column. The foreign key is the INDEXID column.
| Column name | Data type | Nullable? | Description |
|---|---|---|---|
| INDEXID | INTEGER | No | Uniquely generated index ID for the text search index. |
| PARAMETER | VARCHAR(30) | No | Parameters that are specified for the text search index in the SYSPROC.SYSTS_CREATE stored procedure. |
| VALUE | VARCHAR(512) | No | Values for the specified parameters. |