IBM Books
(C) IBM Corp. 2000

DB2 Net Search Extender Administration and User's Guide

NUMBEROFMATCHES

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 ]