Before the Enhanced Full-Text Search engine can process full-text searches, you must create text indexes for the source tables in the user database. After the text indexes are created, you must update them when the source data changes to keep the text indexes current. To create and maintain the text indexes:
Set up the source table for indexing (see “Setting up source tables for indexing”).
Create the text indexes and index tables (see “Creating the text index and index table”).
Bring the databases online for full-text searches (see “Bringing the database online for full-text searches”).
Propagate changes in the user data to the text indexes (see “Propagating changes to the text index”).
If you are replicating text indexes, set up text indexing in the destination database (see “Replicating text indexes”).
For an example of setting up a text index, see the sample script sample_text_main.sql in the $SYBASE/$SYBASE_FTS/sample/scripts directory.
