You can use the following DB2® built-in search functions in DB2 Text Search. The schema of these functions is SYSIBM.
- CONTAINS
- Returns a NULL or an INTEGER value of 0 or 1 depending on whether
the input text document matches the text search condition
- SCORE
- Returns a NULL or a DOUBLE value between 0 and 1 indicating the
extent to which the text document meets the search criteria.
- xmlcolumn-contains
- Returns a NULL or an INTEGER value 1 or 0 depending on whether
the input text document of XML data type matches the text search condition
DB2 10.5 for Linux, UNIX, and Windows