DB2 Net Search Extender provides the following methods for searching text:
For SQL scalar search functions, the chapter describes the following areas:
Refer to SQL scalar search function and the SQL table-valued function for a description of the syntax.
Refer to Syntax of search arguments for a description of the syntax.
For the stored procedure search function, the chapter describes the following areas:
For the SQL Table-Valued Function, the chapter describes the following areas:
Refer to SQL scalar search function and the SQL table-valued function for a description of the syntax.
There is also information on search performance considerations that you may need to take into account.
Before searching, ensure that all the appropriate indexing steps, described in Creating and maintaining a text index, involving the different data types are considered.
The system shell interprets special characters such as ?, (, ), *, !, and ". Therefore, if the command contains these characters, you must use quotation marks or an escape character.
Here is an example of a UNIX command that uses special characters:
db2 "SELECT * from sample WHERE CONTAINS (DESCRIPTION, '\"enable\"') = 1"