default null vs not null

checky76 · New User Joined: 13 Oct 2007 Posts: 10 Location: Vienna

hi,

i have a table with some columns defined with default null (column systemcode_1)
when i select column SYSTEMCODE_1 <> '91' and the columns is null no result will be displayed.
when i select AND SYSTEMCODE_1 <> '91' or is null then result is ok.

is this normal in db2 ?

regards
christian

Anuj Dhawan · Posted: Mon Jul 16, 2012 3:31 pm

What do you call as "result is ok"?

checky76 · New User Joined: 13 Oct 2007 Posts: 10 Location: Vienna

then i get the row i expect.

i mean that when i sql >< '81' null values must be included ?

regards
Christian

GuyC · Posted: Mon Jul 16, 2012 5:39 pm

checky76 · New User Joined: 13 Oct 2007 Posts: 10 Location: Vienna

thanks for the info.

regards
christian

GuyC · Posted: Mon Jul 16, 2012 7:26 pm

google a bit about "DB2 is distinct from"
This should give you some links where it is all explained.