DataStage NULL comparison

Small update on DataStage not equal to operator. In DataStage var1 <> ‘Y’ does not include cases where var1 can be NULL. If you want to check if var1 is not Y but can be NULL then you should use: var1 <> ‘Y’ or isNull(var1 )