|
Problem IC82157
|
Status: Closed |
CAN NOT CREATE NICKNAME FOR CLASSIC FEDERATION OBJECT BY USING ODBC WRAPPER IN V95FP9 |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Classic Federation Server ODBC driver doesn't support ODBC 3.0
type SQL_C_SBIGINT, so it
block creating nickname for Classic Federation Server like this:
You may meet the following error when creating nickname for a
classic federation object by using odbc wrapper:
create nickname nick1 for <your_server>.<schema>.<table1>
DB21034E The command was processed as an SQL statement because
it was not a
valid Command Line Processor command. During SQL processing it
returned:
SQL1822N Unexpected error code "HY003" received from data
source "<your_server>".
Associated text and tokens are " SQLBindCol - Error code:
x00560051. Message
look-up f". SQLSTATE=560BD
The x00560051 error means Classic Federation Server SQLBindCol
doesn't support SQL_C_SBIGINT ODBC C type.
You may be also failed to create nickname with such kind of ODBC
drivers which is not totally abide by ODBC 3.x specification. |
| Problem Summary: |
User affected:
Users of the ODBC wrapper against IICF in InfoSphere
Federation Server
Problem description and summay:
See error description |
| Local Fix: |
|
| available fix packs: |
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 |
Problem was fistly fixed in Version 9.7, FixPak 6. This
fix should be applied on the federation Server. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 20.03.2012
10.06.2012
10.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
