0 / 0
Supported Boolean expressions and operators (DataStage)

Supported Boolean expressions and operators (DataStage)

Certain Boolean expressions and operators are supported.

The following list summarizes the Boolean expressions that are supported. In the list, BOOLEAN denotes any boolean expression.

  • true
  • false
  • six comparison operators: =, <>, <, >, <=, >=
  • is null
  • is not null
  • like 'abc' (the second operand must be a regular expression)
  • between (for example, A between B and C is equivalent to B <= A and A> = C)
  • not BOOLEAN
  • BOOLEAN is true
  • BOOLEAN is false
  • BOOLEAN is not true
  • BOOLEAN is not false

Any of these can be combined using AND or OR.

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