SYSTEXTCONFIG system view

Each row in the SYSTEXTCONFIG system view describes one text configuration object, for use with the full text search feature. The underlying system table for this view is ISYSTEXTCONFIG.

For more information about what each configuration setting means, see Text configuration object settings.

For more information about the full text search feature, see Full text search.

Column name Data type Description
object_id UNSIGNED BIGINT The object ID for the text configuration object.
creator UNSIGNED INT The creator of the text configuration object.
term_breaker TINYINT The algorithm used to separate a string into terms or words. Values are 0 for GENERIC and 1 for NGRAM. With GENERIC, any string of one or more alphanumeric characters separated by non-alphanumerics are treated as a term. NGRAM is for approximate matching or for documents that do not use a whitespace to separate terms.
stemmer TINYINT For internal use only.
min_term_length TINYINT

The minimum length, in characters, allowed for a term. Terms that are shorter than min_term_length are ignored.

The MINIMUM TERM LENGTH setting is only meaningful for the GENERIC term breaker. For NGRAM text indexes, the setting is ignored.

max_term_length TINYINT

For GENERIC text indexes, the maximum length, in characters, allowed for a term. Terms that are longer than max_term_length are ignored.

For NGRAM text indexes, this is the length of the n-grams into which terms are broken.

collation CHAR(128) For internal use only.
text_config_name CHAR(128) The name of the text configuration object.
prefilter LONG VARCHAR The function and library name for an external prefilter library.
postfilter LONG VARCHAR For internal use only.
char_stoplist LONG VARCHAR Terms to ignore when performing a full text search on CHAR columns. These terms are also omitted from text indexes. This column is used when the text configuration object is created from default_char.
nchar_stoplist LONG NVARCHAR Terms to ignore when performing a full text search on NCHAR columns. These terms are also omitted from text indexes. This column is used when the text configuration object is created from default_nchar.
external_term_breaker LONG VARCHAR The function and library name for an external term breaker library.
 Constraints on underlying system table