The Enhanced Full-Text Search engine installation copies the sample_text_main.sql script to the $SYBASE/$SYBASE_FTS/sample/scripts directory. This script illustrates the following operations:
Setting up a text index.
Modifying data and propagating changes to the collections. This includes inserts, updates, and deletes.
Dropping a text index.
Execution of this script is not required for installation or configuration; Sybase supplies the script as a sample.
Before you run the sample_text_main.sql script:
Your Adaptive Server and Enhanced Full-Text Search engine must be configured and running.
Use a text editor to edit the sample_text_main.sql script. Change “YOUR_TEXT_SERVER” to the name of your Enhanced Full-Text Search engine in Step 4 in the sample_text_main.sql script.
Verify that your model database contains a text_events table. If your model database is not configured this way, you must:
Modify the sample_text_main.sql script to exit after creating the database
Apply the installevent script to the new database. See “Running the installevent script”.
Execute the remainder of the sample script
Direct the script as input to your Adaptive Server. For example, to run the sample_text_main.sql script on an Adaptive Server named MYSVR:
isql -Ulogin -Ppassword -SMYSVR -i $SYBASE/$SYBASE_FTS/sample/scripts/sample_text_main.sql -omain.out
When you finish with this sample environment, log in to your Adaptive Server and drop the sample database. For example:
1> use master 2> go 1> drop database sample_colors_db 2> go
You can re-run the sample_text_main.sql necessary.
