DB2 FOR LUW / DB2FORLUW / A50 - DB2

When fetching DB DECFLOAT data into DECIMAL output columns CLI 
returns a ?CLI0111E  Numeric value out of range.? , if  the 
length of the DECFLOAT data is longer than 31 digits. 
 
For example: 
 
VALUES ( CAST ( '1.000000000000000000000000000000' AS DECFLOAT ) 
) 
      can be fetched without problems via CLI into a DECIMAL( 
N,3 ) resulting in value 1.000. 
 
VALUES ( CAST ( '1.0000000000000000000000000000000' AS DECFLOAT 
) ) 
      returns a ?CLI0111E  Numeric value out of range.? If you 
try to fetch this via CLI into a DECIMAL( N,3 )

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 4.                      * 
****************************************************************

DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

First fixed in DB2 Version 10.5 Fix Pack 4.

keiner bekannt / siehe Local-Fix

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

28.03.2014
20.10.2014
20.10.2014