DB2 FOR LUW / DB2FORLUW / A50 - DB2

If SQL is doing SUBSTR against column that is defined with 
CODEUNITS32 
(Example: "ONE" CLOB(500M CODEUNITS32)), 
                   SUBSTR("ONE",  start, length) ) 
 
then it is possible that data will be truncated. 
 
Example of truncated result shown in hex: 
 
hex(SUBSTR(ONE, 18970, 2))      ----> E0B9 
 
As a workaround , please, use SUBSTRING function with 
CODEUNITS32: 
 
hex of SUBSTRING(ONE, 18970, 2,CODEUNITS32) ---->  E0B980D79E

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to v10.5 fp7 or above                                 * 
****************************************************************

As a workaround , please, use SUBSTRING function with 
CODEUNITS32: 
 
hex of SUBSTRING(ONE, 18970, 2,CODEUNITS32) ---->  E0B980D79E

First fixed in v10.5 fp7

not known / see Local fix

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

29.07.2015
24.01.2016
24.01.2016