DB2 FOR LUW / DB2FORLUW / 950 - 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 SCALAR  FUNCTION on DECFLOAT with INFINITY VALUE       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* THE ROUND SCALAR  FUNCTION CAN RETURN THE WRONG RESULT ON A  * 
* DECFLOAT INPUT 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.5 Fix Pack 6a for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
 

THE ROUND SCALAR  FUNCTION CAN RETURN THE WRONG RESULT ON A 
DECFLOAT INPUT VALUES OF Infinity/-Infinity. 
First Fixed in DB2 Version 9.5 Fix Pack 6a.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC64092 
Nachfolger : 

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

24.08.2009
14.05.2010
07.02.2011

9.5.FP6