I ran into this issue yesterday, figured out a work around, but am still curious.
We had a column in a db2 db set up as 'char', not really necessary. Lots of numbers were less than the fixed width of 7, such as '54556 ', some where completely blank ' '.
When setting up an alerter like this -
'field name' 'equals' ' '
and 'second field' 'equals' '2' , show red.
You'd think it would either fail entirely (no red) or work for those that fit both conditions. What it did was show red for anything where the second condition was correct. It basically ignored the first condition.
Why does this occur?
We switched to varchar after all, but our main default value will remain 7 spaces (rather than NULL), so my work around was to create a variable where this is changed to 7 x's and then change the alerter to look for xxxxxxx instead of ' '.
Now that works, but it seems the alerter functionality is broken.
Thanks for any insight.
We had a column in a db2 db set up as 'char', not really necessary. Lots of numbers were less than the fixed width of 7, such as '54556 ', some where completely blank ' '.
When setting up an alerter like this -
'field name' 'equals' ' '
and 'second field' 'equals' '2' , show red.
You'd think it would either fail entirely (no red) or work for those that fit both conditions. What it did was show red for anything where the second condition was correct. It basically ignored the first condition.
Why does this occur?
We switched to varchar after all, but our main default value will remain 7 spaces (rather than NULL), so my work around was to create a variable where this is changed to 7 x's and then change the alerter to look for xxxxxxx instead of ' '.
Now that works, but it seems the alerter functionality is broken.
Thanks for any insight.