Mandatory.
Specify whether the condition specified in the operation(s) field is to be used to select or omit records when found to be true.
Rules
Allowable values are:
SELECT | Use operation to select records |
OMIT | Use operation to omit records |
blank | Form an "and" with previous SELECT/OMIT operation |
Tips & Techniques
- Using SELECT or OMIT implies an OR relationship with the preceding select/omit statement. When adding more than one select/omit criteria, the use of a blank value indicates that the criteria is being in an AND relationship with previous criteria. Refer to Select/Omit And/Or.