Hi,
When we compare two fields
If (link1.A=Link1.B) then 1 Else 0
Now when Link1.B is a null value what would be the result?
comparing with null values
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If link.B is null then (link.A = link.B) is null.
The rule in server jobs (in DataStage BASIC) is that, if the test expression is null, then the Else path is taken, on the grounds that one can not assert that null is "true". The Else path is taken if the expression is not true (which is not necessarily the same thing as "false").
Welcome to the world of no data types, where rules of this kind are necessary.
The rule in server jobs (in DataStage BASIC) is that, if the test expression is null, then the Else path is taken, on the grounds that one can not assert that null is "true". The Else path is taken if the expression is not true (which is not necessarily the same thing as "false").
Welcome to the world of no data types, where rules of this kind are necessary.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.