DB2 FOR LUW / DB2FORLUW / 970 - DB2

When the first parameter of the DECODE function is a string 
type, it may not match a NULL value at an even number position 
of the 
DECODE function.  This also applies to '' (empty string) when 
database is in ORA mode. 
 
Example: 
  select decode (a1, null, 'null', '00') as a1 
  from (select cast (NULL as CHAR) as a1 
             from table (values(1))); 
 
   returns '00' instead of 'null'.

**************************************************************** 
* USERS AFFECTED:                                              * 
* When using  'DB2_COMPATIBILITY_VECTOR=ORA'                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2_v97fp6                                        * 
****************************************************************

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
 

keiner bekannt / siehe Local-Fix

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

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

17.01.2012
09.04.2014
09.04.2014