IBM Books
(C) IBM Corp. 2000

DB2 Net Search Extender Administration and User's Guide

CONTAINS

The CONTAINS scalar function searches for text in a text document indexed by Net Search Extender. It returns the INTEGER value 1 if the document contains the text, or any relation specified in the search argument. Otherwise, it returns 0.

Function syntax

>>-CONTAINS--(--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 CONTAINS query on a text index created on a view.


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