DB2 - Problembeschreibung
Problem IT07906 | Status: Geschlossen |
NULL AS CHAR(0) IS PUSHDOWN TO ORACLE FROM DB2 WHICH CAUSES ERROR ORA-01723: ZERO-LENGTH COLUMNS ARE NOT ALLOWED | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
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 " | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Anyone who encounters the error * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * upgrade to db2_v105fp7 * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 24.03.2015 21.01.2016 21.01.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |