|
Problem IC71560
|
Status: Closed |
"BINARY_REP" COLUMN OPTION FOR REMOTE INFORMIX BYTE DATA TYPE MAKES SQL FAILED |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Informix BYTE is a kind of LOB data type. With the "BINARY_REP"
column option, the predicate related to this column may be
pushed down to remote data source, which makes the SQL statement
failed because Informix BYTE can't be directly compared or
bound.
The possible error message would be:
SQL1822N Unexpected error code "-615" received from data source
"InformixSer".
Associated text and tokens are "Blobs are not allowed in this
expression.".
SQLSTATE=560BD
Return Status = 0 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Federation Server *
****************************************************************
* PROBLEM DESCRIPTION: *
* Incorrect to pushdown informix column with BYTE data type. *
* The possible errorm message will be: *
* SQL1822N Unexpected error code "-615" received from data *
* source "INFODB". *
* Associated text and tokens are "Blobs are not allowed in *
* this expression.". *
* SQLSTATE=560BD *
* Return Status = 0 *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Federation server database version 9.7.0.4 *
**************************************************************** |
| Local Fix: |
Delete the "BINARY_REP" column option |
| available fix packs: |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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
|
| Solution |
Federation server database version 9.7.0.4 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 29.09.2010
31.01.2011
31.01.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.0.4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
