DB2 FOR LUW / DB2FORLUW / 970 - DB2

The scenario can be re-created as follows: 
 
 
Table creation: create table dectest (col1 decfloat(34)); 
Insert special values like Infinity/-Infinity: insert into 
dectest values(Infinity),(-Infinity) 
 
The ROUND function may return Nan instead of Infinity/-Infinity. 
The output appears as follows: 
 
 
select col1,ROUND(col1,5) from dectest 
 
COL1        2 
 
------------------------------------------ 
------------------------------------------ 
     Infinity 
        NaN    (wrong result we expect Infinity) 
SQL0364W  DECFLOAT exception "INVALID OPERATION" has occurred 
during "BUILT-IN 
FUNCTION" operation.  SQLSTATE=0168D 
          -Infinity 
       NaN  (wrong result , expect: -Infinity) 
SQL0364W  DECFLOAT exception "INVALID OPERATION" has occurred 
during "BUILT-IN 
FUNCTION" operation.  SQLSTATE=0168D

**************************************************************** 
* USERS AFFECTED:                                              * 
* ROUND SQL FUNCTION on DECFLOAT with INFINITY VALUE           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* THE ROUND SQL FUNCTION CAN RETURN THE WRONG RESULT ON        * 
* ADECFLOATINPUT VALUES OF Infinity/-Infinity                  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* install this fix                                             * 
****************************************************************

Rewrite the SQL query  to have a case statement which avoids 
using the ROUND function on these 
special values.

DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

THE ROUND SQL FUNCTION CAN RETURN THE WRONG RESULT ON A DECFLOAT 
INPUT VALUES OF Infinity/-Infinity

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

22.10.2009
31.05.2010
31.05.2010