A function that returns a set of values from the index’s Find() method.
can be used with the %FIND
predicate in a WHERE
clause to supply the oref of an object that provides an abstract representation encapsulating a set of values. These values are commonly row IDs returned by a method called at query run time. SEARCH_INDEX
invokes the index’s Find()
method to return this oref. This usage is shown in the following example:
SELECT Name FROM Sample.Person AS P
WHERE P.Name %FIND SEARCH_INDEX(Sample.Person.NameIDX)
The index must be found within the tables referenced by the SQL statement. An SQLCODE -151 error is generated if the specified index-name
does not exist within the tables used by the SQL statement. An SQLCODE -152 error is generated if the specified index-name
is not fully qualified, and is therefore ambiguous (could refer to more than one existing index) within the tables used by the SQL statement.