DB2 FOR LUW / DB2FORLUW / 970 - DB2

In VARCHAR2 compatibility mode, calling TO_CHAR( 
character-expression, format-string ) should implicitly cast the 
first argument to a number and perform numeric to string 
conversion using the format string provided. 
Instead, the first argument is implicitly cast to a timestamp 
and the second argument is assumed to be a timestamp format 
string. 
This is likely to result in SQLCODE SQL20447N and SQLSTATE 
22007.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB version 9.7 fixpack 9.                    * 
****************************************************************

Explicitly cast the first argument to a numeric data type

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
 

Problem was first fixed in DB2 UDB Version 9.7 FixPack 9

keiner bekannt / siehe Local-Fix

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

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

04.07.2013
23.12.2013
07.05.2014

9.7.FP9