xaminmo: (Logo Tivoli Certified)
[personal profile] xaminmo
I didn't notice this in TSM 5.5, but in TSM 6.1, the string '' is not the same as the value NULL. I probably just missed it, but just in case...

This will fail:

select NODE_NAME,PLATFORM_NAME from nodes -
  where PLATFORM_NAME NOT in ('Linux86','WinNT') -
  or PLATFORM_NAME=''


But this will work:

select NODE_NAME,PLATFORM_NAME from nodes -
  where PLATFORM_NAME NOT in ('Linux86','WinNT') -
  or PLATFORM_NAME is NULL

Profile

eserver: (Default)
IBM POWER servers

June 2017

S M T W T F S
    123
45678 910
11121314151617
18192021222324
252627282930 

Syndicate

RSS Atom

Most Popular Tags

Page Summary

Style Credit

Expand Cut Tags

No cut tags
Page generated Sep. 26th, 2017 07:49 pm
Powered by Dreamwidth Studios