DB2 FOR LUW / DB2FORLUW / 970 - DB2

When comparing fixed character or graphic strings where either
side uses a CASE statement, DB2 may return incorrect results in
VARCHAR2 compatibility mode.

Example:

CREATE TABLE T(C1 CHAR(4))
INSERT INTO T VALUES ('M')
SELECT * FROM T WHERE C1 = CASE WHEN 1=1 THEN 'M' END

Incorrect Result:

C1
----

  0 record(s) selected.

****************************************************************
* USERS AFFECTED:                                              *
* All                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description. The issue will be fixed in v10.1fp6,  *
* 10.5fp9 and later.                                           *
****************************************************************
* RECOMMENDATION:                                              *
* See Error Description. The issue will be fixed in v10.1fp6,  *
* 10.5fp9 and later. Please, check sysroute apars to see where *
* the issue is fixed.                                          *
****************************************************************

From the example above, cast the CASE statement to a fixed
character string of the desired length:

SELECT * FROM T WHERE C1 = CAST((CASE WHEN 1=1 THEN 'M' END) AS
CHAR(1))

C1
--------
M

  1 record(s) selected.

not known / see Local fix

forerunner  : IT18343 
follow-up : 

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

19.12.2016
31.07.2017
31.07.2017