DB2 FOR LUW / DB2FORLUW / 970 - DB2

In a VARCHAR2 enabled database, a query may return wrong results 
when a basic predicate compares a VARGRAPHIC value with a CHAR 
value.  For example, the following query should return one row 
but returns zero rows instead: 
 
      create table T( VG vargraphic(10), C char(2) ); 
      insert into T values ( U&'\00C4', U&'\00C4' ); 
      select * from T where VG = C;

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Use the local fix or upgrade to V9.7 FP7                     * 
****************************************************************

Explicitly cast the CHAR value to VARGRAPHIC: 
 
select * from T where VG  = VARGRAPHIC(C);

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
 

First fiixed in V9.7 FP7

not known / see Local fix

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

28.08.2012
20.10.2012
20.10.2012

9.7.FP7