IBM IDS ENTRP E / 5724L2304 / B15 - IDS 11.50

If a table has been created with a default value defined on a 
VARCHAR column, calling the trim() function on 
sysdefaults.default to report the default value for this column 
as part of a concatenated string will not return the correct 
result set.  Any columns or string values that follow 
sysdefaults.default in the concatenation will be truncated from 
the result. 
 
For example if you have a table with a default value of 'N' 
defined for the varchar column, the trim operation: 
 
select 'test ' || trim(sysdefaults.default) || ' end of string' 
from ..... 
 
Would report: 
 
     (expression)  test N 
 
     1 row(s) retrieved. 
 
 
Instead of: 
 
     (expression)  test N end of string 
 
     1 row(s) retrieved.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users using string concatenation function of SQL             * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to 12.10.xC5 or earlier PID if available             * 
****************************************************************

not known / see Local fix

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

27.02.2014
16.10.2015
16.10.2015

12.10.xC5