DB2 FOR LUW / DB2FORLUW / 970 - DB2

In a VARCHAR2 enabled database, an assignment of an empty string 
value to a CHAR, VARCHAR, GRAPHIC or VARGRAPHIC should produce a 
NULL value.  However, if a string literal is not empty, consists 
of all blanks is passed as an argument to the scalar functions 
CHAR, VARCHAR, GRAPHIC or VARGRAPHIC, and has a specified length 
of 0, then an empty string is returned instead of the expected 
NULL.  The returned string might look like the following sample: 
 
values char('   ',0) 
 
1 
- 
 
 
  1 record(s) selected.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7 fix pack 10                       * 
****************************************************************

Change the string literal to an empty string.  For example, 
changing the string literal to CHAR('',0) will fix this issue.

First fixed in DB2 version 9.7 fix pack 10

not known / see Local fix

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

16.04.2014
12.11.2014
07.04.2015

9.7.FP10