IBM Books
(C) IBM Corp. 2000

DB2 Net Search Extender Administration and User's Guide

Input parameters

See TextSearch stored procedure for information, as well as:

sqlQuery
An SQL statement that specifies the columns and rows of the result table returned by the stored procedure. The statement has following structure for non-ranked queries (ranking-Flag=0):
select ...from ... where ...  

The where-clause (belonging to a from-clause referencing the table, or view the index was created on), must contain "<keycolumn> in (%s)" in a place where SQL allows an IN-predicate.

The statement has following structure for ranked queries (ranking-Flag=1):

select ...from ... where ... 
The select-clause must contain a column-reference "RSCORE" in a place where SQL allows an expression. The from-clause must contain a "%s" where SQL allows a table-reference. The where-clause (belonging to a from-clause referencing the table or view the index was created on), must contain "%s" in a place where SQL allows an IN-predicate.


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