IBM Books
(C) IBM Corp. 2000

DB2 Net Search Extender Administration and User's Guide


Stored procedure with SQL query

This stored procedure allows the combing of results from a text query with an additional SQL query. Its use is restricted to indexes created on a table/view with a single key-column.

Textsearch(
    IN        query                   VARCHAR(32000),
 
 
TextSearchSql(
    IN	     query			              VARCHAR(32000),
    IN	     indexSchema		         VARCHAR(128),
    IN	     indexName		           VARCHAR(18),
    IN	     resultFirstRow		      BIGINT,
    IN	     resultNumberRows	     BIGINT,
    IN 	     scoringFlag		        INTEGER,
    IN       sqlQuery             VARCHAR(32000),
    INOUT 	  searchTermCounts	    VARCHAR(32000),
    OUT	     totalNumberOfResult  BIGINT)
 


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