IBM InfoSphere DataStage and InfoSphere QualityStage, Version 8.5 IBM InfoSphere DataStage and InfoSphere QualityStage, Version 8.5Not (expression)
expression is the expression whose result is inverted. If expression is true, 0 is returned if false, 1 is returned. If expression is a null value, null is returned.
expression is false if it evaluates to 0 or is an empty string. Any other value (except null) is true.
Here are some examples of the use of the Not function to invert the truth value of expressions:
Value1 = 5 Value2 = 5 Boolean = Not(Value1 - Value2);* Boolean = 1, that is, True Boolean = Not(Value1 + Value2);* Boolean = 0, that is, False Boolean = Not(Value1 = Value2);* Boolean = 0, that is, False
This topic is also in the IBM InfoSphere DataStage Server Job Developer's Guide.
