QSYS2.SYSTEXTCOLUMNS administration table
You can see information about the text columns for a text search index in the QSYS2.SYSTEXTCOLUMNS administration table. Each text search index has an index ID, text column names, and the schema name of the base table.
The following table shows the contents of the QSYS2.SYSTEXTCOLUMNS administration table. The primary key for this table is the INDEXID column with the COLUMNNAME 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. |
| COLUMNNAME | VARCHAR(128) | No | Unqualified name of the text column. |
| TABLESCHEMA | VARCHAR(128) | No | Schema name of the base table. |
| TABLENAME | VARCHAR(128) | No | Unqualified name of the base table. |
| LANGUAGE | VARCHAR(5) | No | The language that the text search server uses for the linguistic processing of text documents. The default value is en_US (English). |
| FUNCTIONSCHEMA | VARCHAR(128) | Yes | The schema of a user-defined function used by OMNIFIND to access text documents that are in a column that is not of a supported data type, or that are stored elsewhere. |
| FUNCTIONNAME | VARCHAR(18) | Yes | The name of a user-defined function used by OMNIFIND to access text documents that are in a column that is not of a supported data type, or that are stored elsewhere. |
| CCSID | INTEGER | No | The coded character set identifier that is used for a text search index on a column with a binary data type. |
| FORMAT | VARCHAR(30) | No | The format of text documents in the column. The supported format values are TEXT, HTML, XML, and INSO. |
| KEYCOLUMNCOUNT | INTEGER | No | The count of key columns for the text search index. |
| KEYCOLUMNNAMES | VARCHAR(1200) | No | The key column names for the text search index. |