CREATE TEXT CONFIGURATION Statement

Note: This statement requires the Unstructured Data Analytics (IQ_UDA) license.

Quick Links:

Syntax

CREATE TEXT CONFIGURATION [ owner.]new-config-name 
   FROM [ owner.]existing-config-name

Parameters

(back to top)

FROM – specifies the name of a text configuration object to use as the template for creating the new text configuration object. The names of the default text configuration objects are DEFAULT_CHAR and DEFAULT_NCHAR. DEFAULT_CHAR is supported for SAP Sybase IQ tables only; DEFAULT_NCHAR is supported on SQL Anywhere tables only.

Examples

(back to top)

Example 1 – creates a text configuration object, max_term_sixteen, using the default_char text configuration object, then use ALTER TEXT CONFIGURATION to change the maximum term length for max_term_sixteen to 16:
```
CREATE TEXT CONFIGURATION max_term_sixteen FROM default_char;
```
```
ALTER TEXT CONFIGURATION max_term_sixteen MAXIMUM TERM LENGTH 16;
```

Usage

(back to top)

Create a text configuration object using another text configuration object as a template, then alter the options as needed using the ALTER TEXT CONFIGURATION statement.

To view the list of all text configuration objects and their settings in the database, query the SYSTEXTCONFIG system view.

Side Effects:

Automatic commit.

Permissions

(back to top)

Text configuration object to be owned by self –

Requires CREATE TEXT CONFIGURATION system privilege.

Text configuration object to be owned by any user – Requires one of:

CREATE ANY TEXT CONFIGURATION system privilege.
CREATE ANY OBJECT system privilege.

All text configuration objects have PUBLIC access. Any user with privilege to create a TEXT index can use any text configuration object.