A text search argument is specified when searching for terms in text documents. It consists of search parameters and one or more search terms. The SQL scalar text search functions that use text search arguments are CONTAINS and SCORE.
For information on CONTAINS and SCORE, see CONTAINS and SCORE.
For more information on text search, see OmniFind Text Search
Server for DB2 for i 
.--------------------------------. V | >>-qualified-clause----+----------------------------+-+-------->< '-operator--qualified-clause-' operator |--+-AND-+------------------------------------------------------| '-OR--' qualified-clause |--+----------+--clause--+-------+------------------------------| '-modifier-' '-boost-' modifier |--+- + -+------------------------------------------------------| +- - -+ '-NOT-' clause |--+-unqualified-term-+-----------------------------------------| '-opaque-term------' boost |--+------------+-----------------------------------------------| '- ^ -number-'
A search argument is a term or sequence of terms, separated by white space, specified when searching in text documents. It consists of one or more search terms and various optional search parameters.
To perform a simple search, you can enter one or more terms. The search engine returns documents that contain all of those terms or variations of those terms. For example, if you perform a search on the term king, documents containing king are returned. By default, the search engine also returns variants of the search term. Thus, documents containing kings are also returned. Similarly, when you search on two terms, the search engine returns documents containing both terms. If you want the terms to be searched as an exact phrase, simply add quotation marks.
The more specific the search term you use, the more precise the results. However, you may also want to refine your searches by using one or more of the following options:
Similar to search conditions in SQL, parentheses can be used to determine which qualified clauses and operators are evaluated first. If parentheses are not specified, AND is applied before OR.
If a character in clause is one of the characters that has a special meaning in the syntax of the search argument, an escape character (\) can be used to indicate that the subsequent character should be treated as a regular character in the clause.
An opaque query term is so called because it is
not parsed by the linguistic query parser; opaque terms are identified
by their syntax. The opaque term used for text search queries that
include XML markup is @xmlxp,, for example: @xmlxp:'/TagA/TagB[.
contains("king")]'
Case sensitivity: Searches are not case sensitive, so a search in Spanish for the exact term "DOS" could return documents containing DOS or dos.