DB2 CONNECT / DB2CONNCT / 970 - DB2

DB2 application may get SQL0303N error when issuing the SELECT 
statement 
on a table with GRAPHIC column against the DB2 z/OS with 
QueryAcceleration enabled. 
 
db2 > connect to  <IDAAdatabase> 
 
db2 => set current query acceleration = all 
DB20000I  The SQL command completed successfully. 
 
db2 => select * from biqry.ebcdictb for read only 
 
COL01INT    COL07GRAP 
----------- ---------------------------------------- 
SQL0303N  A value cannot be assigned to a host variable in the 
SELECT, 
VALUES, FETCH or assignment statement because the data types are 
not compatible. 
SQLSTATE=42806 
 
Because with Query acceleration enabled DB2 z/OS redirects all 
the 
queries to Neteeza database, Netezza does not support GRAPHIC 
type. All 
GRAPHIC are mapped to UTF-8 in Netezza. DB2 client source layer 
was not 
handling this scenario.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to v9.7fp10 or above                                  * 
****************************************************************

First fixed in v9.7fp10

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

25.02.2014
15.12.2014
15.12.2014

9.7.FP10