Search function | Purpose | Page |
---|---|---|
CONTAINS | Searches for text in a particular document. | CONTAINS |
NUMBEROFMATCHES | Searches and returns the number of matches found. | NUMBEROFMATCHES |
SCORE | Searches and returns the score value of a found text document. | SCORE |
DB2EXT.TEXTSEARCH | The SQL table-valued function returns a table of found primary keys, a number of matches, and/or score values. | DB2EXT.TEXTSEARCH |
DB2EXT.HIGHLIGHT | To get information about why a document qualified as a search result. | DB2EXT.HIGHLIGHT |
See Searching for examples of using the SQL scalar search functions and the SQL table-valued function.