DB2 FOR LUW / DB2FORLUW / A10 - 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 users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.1.0.4.                             * 
****************************************************************

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

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

The problem is first fixed in DB2 version 10.1.0.4.

keiner bekannt / siehe Local-Fix

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

16.04.2014
08.05.2014
26.05.2014