|
Problem IT07500
|
Status: Closed |
NULL AS CHAR(0) IS PUSHDOWN TO ORACLE FROM DB2 WHICH CAUSES ERROR ORA-01723: ZERO-LENGTH COLUMNS ARE NOT ALLOWED |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 fp5 *
**************************************************************** |
| Local Fix: |
|
| Solution |
Fixed in DB2 10.1 fp 5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 04.03.2015
13.07.2015
13.07.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.5
|
 |
