DB2 FOR LUW / DB2FORLUW / A10 - 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 version 10.1 fix pack 3                       * 
****************************************************************

Explicitly cast the first argument to a numeric data type

DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

First fixed in DB2 version 10.1 fix pack 3

keiner bekannt / siehe Local-Fix

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

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

24.07.2013
08.10.2013
07.05.2014