SYSIBMTS.SYSTEXTCOLUMNS administration table
The SYSIBMTS.SYSTEXTCOLUMNS administration table provides information about the text column for a text search index, such as the index ID for the text search index, the name of the text column, and the schema name of the base table.
The following table shows the contents of the SYSIBMTS.SYSTEXTCOLUMNS administration table. The primary key for this table is the INDEXID column in conjunction 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 that is to be used by the text search feature for Db2 for z/OS® 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 that is to be used by the text search feature for Db2 for z/OS 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. |