DB TSINDEX

DB_TSINDEX

Class

Environment Variables / Symbols

Purpose

Must be set to enable Text Search Index functionality

See Also

SET TSLENGTH, TSPOS(), TSWORD()

Description

The DB_TSINDEX environment variable / symbol is used to enable Text Search Index functionality. It must be set to "ON" for Text Search Indexes to operate correctly.

Text Search Indexes are created using the TSWORD() function in the key and searched using the TSPOS() function.

Example

? getenv([DB_TSINDEX])
'''ON'''
use example
index on tsword(first_name+last_name,1) to namesearch

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer