DB2 FOR LUW / DB2FORLUW / 970 - DB2

Scalar function DECFLOAT Failed with SQL0420N due to query 
re-write causing invalid cast. 
 
Problem could occur in this scenario: 
--------------------- 
  Input varchar(100) ; 
 
  SubInput    varchar(10) ; 
BEGIN 
... 
  if length(Input) <> 4 
  then 
      SubInput := to_number(substr(Input, 2, 3)) || ',' || 
to_number(substr(Input, 9)) ; 
  end if ; 
--------------------

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The Scalar function DECFLOAT fails with a SQL0420N error due * 
* to an invalid cast during query re-write.                    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 5                        * 
****************************************************************

n/a

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 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in DB2 Version 9.7 Fix Pack 5

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

28.03.2011
12.12.2011
12.12.2011

9.7.FP5