Text search routines

This grouping of routines and views can be used to manage the Text Search feature and the text search indexes it uses.

SYSTS_ADMIN_CMD procedure - Run text search administration commands
The SYSTS_ADMIN_CMD procedure is used by applications to run text search administrative commands using the SQL CALL statement.
SYSTS_ALTER procedure - Change the update characteristics of an index
This procedure is used to change the update characteristics of an index.
SYSTS_CLEANUP procedure - Remove invalid text search indexes
This procedure removes invalid text search indexes and their associated collections from the database.
SYSTS_CLEAR_COMMANDLOCKS procedure - Remove command locks for text search indexes
This procedure removes all command locks for a specific text search index or for all text search indexes in the database.
SYSTS_CLEAR_EVENTS procedure - Delete indexing events from an index's event table
This procedure deletes indexing events from an index's event table used for administration.
SYSTS_CONFIGURE procedure - Configure current database for text search
The SYSTS_CONFIGURE procedure applies text search server connection information to the text search catalog.
SYSTS_CREATE procedure - Create a text search index on a column
The SYSTS_CREATE procedure creates a text search index for a text column by issuing the Text Search CREATE INDEX command on the database server. After you create and update a text search index, you can search the column data by using text search functions.
SYSTS_DISABLE procedure - Disable current database for text search
The procedure disables Text Search for the current database.
SYSTS_DROP procedure - Drop text search index
The SYSTS_DROP procedure drops an existing text search index associated with any table column.
SYSTS_ENABLE procedure - Enable current database for text search
The SYSTS_ENABLE procedure enables Text Search for the current database.
SYSTS_UPDATE procedure - Update the text search index
The SYSTS_UPDATE procedure updates the text search index to reflect the current contents of the text column with which the index is associated.
SYSTS_UPGRADE_CATALOG procedure - Upgrade the text search catalog
This procedure upgrades the Text Search catalog, including the administrative tables and administrative views, to the latest product version.
SYSTS_UPGRADE_INDEX - Upgrade text search indexes
This procedure updates Text Search index information in database catalog tables and text search catalog tables.

Parent topic: Supported built-in SQL routines and views