(C) IBM Corp. 2000
DB2 Net Search Extender Administration and User's Guide
The NUMBEROFMATCHES scalar function searches in text documents and returns
an INTEGER value indicating how many matches resulted per document.
Function syntax
>>-NUMBEROFMATCHES--(--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 NUMBEROFMATCHES query on a text index created on a
view. |
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]