IBM Books
(C) IBM Corp. 2000

DB2 Net Search Extender Administration and User's Guide

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

>>-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 Chapter 14, Syntax of search arguments.
Note

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


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]