Expressions
The behavior of the filter operator is governed by expressions that you set.
You can use the following elements to specify the expressions:
- Fields of the input data set
- Requirements involving the contents of the fields
- Optional constants to be used in comparisons
- The Boolean operators AND and OR to combine requirements
When a record meets the requirements, it is written unchanged to an output data set. Which of the output data sets it is written to is either implied by the order of your -where options or explicitly defined by means of the -target suboption.
The filter operator supports standard SQL expressions, except when comparing strings.