DB2 FOR LUW / DB2FORLUW / A50 - 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 10.5 fix pack 4                       * 
****************************************************************

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

DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

First fixed in DB2 version 10.5 fix pack 4

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

11.04.2014
08.09.2014
07.04.2015