To write a full-text search query, enter the search parameters as part of an Adaptive Server select statement. Then the Enhanced Full-Text Search engine processes the search. The select statement requires:
A where clause that assigns a Verity language query to the index_any pseudo column
Pseudo columns to further define the parameters of the search (optional)
A join between the IDENTITY column from the source table and the id column from the index table
For example, to return the 10 documents from the copy column of the blurbs table that have the most occurrences of the word “software,” enter:
select t1.score, t2.copy from i_blurbs t1, blurbs t2 where t1.id=t2.id and t1.index_any = "<many> <word> software" and t1.max_docs = 10
Adaptive Server passes the Verity query to the Enhanced Full-Text Search engine to process the search. See “How a full-text search works”.
