z/OS Selection Criteria Operators
Following is a description of the operators available for selection criteria conditions.
For information on how to edit your selection criteria, see Edit z/OS Dataset Selection Criteria.
When defining a formatted selection criteria condition, the format of the field is used to control the available operators and the valid values for entry.
- is equal to: will select all records that contain the specified value in this field.
- is not equal to: will select all records that do not contain the specified value in this field.
- is greater than: will select all records with contents that appear alphabetically after the specified value in this field. The specified value is not selected.
- is less than: will select all records with contents that appear alphabetically before the specified value in this field. The specified value is not selected.
- is greater than or equal to: will select all records with contents that include the specified value and appear alphabetically after the specified value in this field.
- is less than or equal to: will select all records with contents that include the specified value and appear alphabetically before the specified value in this field.
- is between: You must use the colon (:) separator with two values. For example, 5:10 or ABLE:CAIN will select all records that contain data equal to or greater than the first value (before the colon) and less than or equal to the second value (after the colon) in this field.
- is not between: You must use the colon separator with two values. For example, 5:10 or ABLE:CAIN will select all records that contain data less than the first value (before the colon) and greater than the second value (after the colon) in this field.
- contains: will select all records that contains the specified value anywhere within this field (only available for character fields).
- does not contain: will select all records not containing the specified value anywhere within this field (only available for character fields).
- is a valid field: will select all records containing valid data in this field. No value is needed or used with this operator, and it is only available for numeric packed and numeric decimal fields.
is not a valid field: will select all records containing invalid data in this field. No value is needed or used with this operator, and it is only available for numeric packed and numeric decimal fields.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*