0 / 0

Specifying the filter (DataStage)

Last updated: Mar 12, 2025
Specifying the filter (DataStage)

The operation of the filter stage is governed by the expressions you set for the Where property in the Properties section on the Stage tab.

About this task

You can use the following elements to specify the expressions:

  • Input columns.
  • Requirements involving the contents of the input columns.
  • 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 the specified output link. The Where property supports standard SQL expressions, except when comparing strings.

When quoting in the filter, you should use single, not double, inverted commas.