User performing text search queries

Users who perform search queries can use the Db2® Text Search CONTAINS and SCORE functions in an SQL query against a user table. They can also use the xmlcolumn-contains function in an XQuery that references a table with a text search index.

There is no specific Db2 Text Search search authorization. Depending on the access rights that the users are granted on the table that the text search index is created on, the query is permitted or rejected. If users can issue a SELECT statement on a given table, they can also perform a text search on that table.

Users performing the search queries can for example include the following functionality in their queries:
  • Limit the text search to a particular document (using SQL or XQuery)
  • Return a score indicating how well a document compares with other matching documents for a given search argument (using SQL)