DB2 FOR LUW / DB2FORLUW / A10 - DB2

If user is federating Oracle from db2 then db2 may generate NULL 
AS CHAR(0) and push it down to oracle where its not supported. 
 
To test this user may issues below query: 
db2 "select replace ('we are here', 'are', '') from dual 
 
below replace query is generated and pushdown to oracle where 
NULL AS CHAR(0) is not supported: 
REPLACE(:H0 , :H1 , CAST(NULL AS CHAR(0))) 
 which causes below error : 
"ORA-01723: zero-length columns are not allowed "

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 fp5                                           * 
****************************************************************

Fixed in DB2 10.1 fp 5

keiner bekannt / siehe Local-Fix

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

04.03.2015
13.07.2015
13.07.2015