Type the comparison value to be applied to the column when the list of objects is pre-filtered. The comparison value is used in conjunction with the operator specified for the column.
For DB2 Universal Database databases you can specify more than one string as the comparison value for the In and Not in operators. Use a space to separate each comparison value that you want to apply to a column. If you specify a text string as a comparison value, use quotation marks to indicate embedded blanks. For non-DB2 Universal Database databases, such as MVS databases, you cannot specify more than one string as the comparison value.
The results that you receive from the comparison value depend on the operation that you use. For example, if you specify In or Equal to, the comparison value must either contain a string that occurs in the descriptive text associated with the object, or must exactly match the descriptive text string. If neither of these conditions is met, the comparison value is ignored. If, however, you specify Not in or Not equal, the comparison value cannot contain a string that occurs in the descriptive text if a successful comparison is to occur.
For DB2 Universal Database databases you can use the asterisk (*) and percent sign (%) as wild cards in the comparison values for the In and Not in operators. For non-DB2 Universal Database databases, such as MVS databases, you can use the underscore (_) and percent sign (%) as wild cards in the comparison values for the In operator.
[ Top of Page | Table of Contents | Glossary | Index ]