0 / 0
Specifying the filter (DataStage)

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.

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.

Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more