SCORE

The SCORE scalar function searches in text documents and returns a score value for each document found, indicating how well the found document is described by the search argument.

SCORE returns a DOUBLE value. As the search term appears more frequently in the document, the score of the document increases.

Function syntax

Read syntax diagramSkip visual syntax diagram>>-SCORE--(--column-name--,--search-argument--)----------------><

Function parameters

column name
The name of a column. The column must have an associated text index. You can create text indexes by using the administration command DB2TEXT CREATE INDEX.
search-argument
A string of type VARCHAR containing the terms to be searched. See Syntax of search arguments.
Note

You cannot use the SCORE query on a text index created on a view.