IBM Books
(C) IBM Corp. 2000

DB2 Net Search Extender Administration and User's Guide

Free-text search

"Free-text search" is a search in which you express the search term as free-form text. A phrase or a sentence describes in natural language the subject to be searched for. The sequence of words in a free-text query is not relevant. However, for a set of query terms, at least one of the terms must occur in the documents to be searched.

Note that there is no support for the masking of characters or words for search strings in a free-text argument.

For example:

 SELECT AUTHOR, TITLE, SCORE(COMMENT, 
        'IS ABOUT EN_US "something related to dinosaur"')
        FROM DB2EXT.TEXTTAB
        WHERE CONTAINS(COMMENT,
        'IS ABOUT EN_US "something related to dinosaur"') = 1
 

By combining the query with SCORE search function, the search will return documents containing only the word "something" as well.


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