General arithmetic operation rules for DECFLOAT

The following general rules apply to all arithmetic operations on the DECFLOAT data type.

Start of changeIn some instances, negative zero might be the result from arithmetic operations and numeric functions.End of change

Examples involving special values

Start of change
   INFINITY + 1              = INFINITY
   INFINITY + INFINITY       = INFINITY
   INFINITY + -INFINITY      = NAN        -- warning
   NAN + 1                   = NAN
   NAN + INFINITY            = NAN
   1 - INFINITY              = -INFINITY
   INFINITY - INFINITY       = NAN        -- warning
   -INFINITY - -INFINITY     = NAN        -- warning
   -0.0 - 0.0E1              = -0.0
   -1.0 * 0.0E1              = -0.0
   1.0E1 / 0                 = INFINITY
   -1.0E5 / 0.0              = -INFINITY
   1.0E5 / -0                = -INFINITY
   INFINITY / -INFINITY      = NAN        -- warning
   INFINITY / 0              = INFINITY   -- warning
   -INFINITY / 0             = -INFINITY  -- warning
   -INFINITY / -0            = INFINITY   -- warning
End of change
1 The warning is only returned if *YES is specified for the SQL_DECFLOAT_WARNINGS query option.