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.