Searching a text search index

An application programmer can issue an SQL statement with a CONTAINS function or a SCORE function to search a text search index.

Before you begin

The user who is performing the text queries on a Db2 table must have the standard privilege set that is required for any form of query.

Procedure

To search a text search index:

Issue an SQL statement with a CONTAINS function or a SCORE function.

What to do next

To create, update, and search additional text search indexes, repeat this step for each text search index.