(C) IBM Corp. 1996, 1999
Text Extender: Administration and Programming
The CONTAINS function searches for text in a particular text
document. It returns the INTEGER value 1 if the document contains the
text. Otherwise, it returns 0.
Function syntax
>>-CONTAINS--(--handle--,--search-argument--)------------------><
Function parameters
- handle
- An expression whose result is a value of type DB2TEXTH or
DB2TEXTFH. It is usually the name of a handle column containing the
handles of the text documents to be searched.
- search-argument
- A string of type LONG VARCHAR containing the terms to be searched
for. See Chapter 10, Syntax of search arguments.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]