Indicator values in SQL

BSP · #1 (**permalink**) 04-05-04, 06:05

Hi,
I have a query on Indicator fields in DB2.
I am aware that the valid values for Indicator fields are -2,-1,0. But I was told that the indicator fields have values other than these too.
So I was asked to code IndField >=0 instead of IndField =0 when the SQL returns proper values.

Does anyone have any info on this to share.

RKrick · #2 (**permalink**) 04-06-04, 03:17

Your approach is correct. You don't care which values are in the indicator variables. If it's greater or equal zero (>=0), DB2 sent you a value. If it's less than zero (<0), DB2 doesn't has a value for the column (it's null).

HTH,

BSP · #3 (**permalink**) 04-06-04, 13:55

Quote:

Originally posted by RKrick
Your approach is correct. You don't care which values are in the indicator variables. If it's greater or equal zero (>=0), DB2 sent you a value. If it's less than zero (<0), DB2 doesn't has a value for the column (it's null).

HTH,

Thank you for your reply. I was just wondering what is the need to give ' > ', when I am sure it would be equal to zero. Is any any positive value for the indicator??

RKrick · #4 (**permalink**) 04-07-04, 02:09

AFAIK, no. The only I've ever seen are -1, -2 and 0. But I will keep checking for <0 to find null values.

Internet Services

Web Development

Digital Marketing

Consumer Tech