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)