(C) IBM Corp. 2000
DB2 Net Search Extender Administration and User's Guide
A search argument is the condition that you specify when searching for
terms in text documents. It consists of search parameters and one or
more search terms.
Examples of search arguments are given in Specifying SQL search arguments, and in a file called search. See the Additional search syntax examples.
The SQL scalar search functions that use search arguments are:
- CONTAINS
- This function uses a search argument to search for text in a particular
text document. It returns the INTEGER value 1 if the document contains
the text, or any relation specified in the search argument. Otherwise,
it returns 0.
- NUMBEROFMATCHES
- This function uses a search argument to search in text documents and
returns an INTEGER value indicating how many matches resulted per
document.
- SCORE
- This function uses a search argument to search in text documents.
It returns a value for each document found, indicating how well the found
document is described by the search argument.
Note |
---|
You use the same syntax in the search arguments of the stored procedure
search and the SQL Table-Valued Function. |
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]