home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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 FixList