Specifies the operator to be applied to the comparison
value for the column. The possible values are:
- In
- The column for the resulting displayed object will contain the string or
strings specified as the comparison value. (This is the only operator
available for non-DB2 Universal Database databases, such as MVS
databases.)
- Not in
- The column for the resulting displayed object will not contain the string
or strings specified as the comparison value.
- Equal to
- The column for the resulting displayed object will contain the exact
string specified as the comparison value.
- Not equal
- The column for the resulting displayed object will not contain an exact
match for the string specified as the comparison value.
For non-DB2 Universal Database databases, such as MVS databases, only the
In operator is valid. If you select another operator from the list, the
operator will default to In and your results will not be as expected.
[ Top of Page |
Table of Contents |
Glossary |
Index ]
[ DB2 List of Books |
Search the DB2 Books ]