The sign condition determines whether the algebraic value of a numeric operand is greater than, less than, or equal to zero.
| Format |
|---|
|
An unsigned operand is either POSITIVE or ZERO.
The operand in a sign condition can be a date field, but is treated as a nondate for the sign condition test. Thus if the operand is an identifier of a windowed date field, date windowing is not done, so the sign condition can be used to test a windowed date field for an all-zero value.
However, if the operand is an arithmetic expression, then any windowed date fields in the expression will be expanded during the computation of the arithmetic result prior to using the result for the sign condition test.
For example, given that:
then this sign condition would evaluate to true:
WIN-DATE IS ZERO
whereas this sign condition would evaluate to false:
WIN-DATE + 0 IS ZERO