This example describes the steps for creating a text index on the plot column of the reviews table in the movies database. This process assumes that:
You have created a reviews table in a new database named movies on the MYSVR server
The reviews table has a column named plot that you are going to index
Adaptive Server and the Enhanced Full-Text Search engine named MYTXTSVR have been configured to connect to each other