home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT10409 Status: Geschlossen

TRUNCATION OF DATA FOR SUBSTR AGAINST COLUMN DEFINED WITH CODEUNITS32

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
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
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to v10.5 fp7 or above                                 * 
****************************************************************
Local-Fix:
As a workaround , please, use SUBSTRING function with 
CODEUNITS32: 
 
hex of SUBSTRING(ONE, 18970, 2,CODEUNITS32) ---->  E0B980D79E
Lösung
First fixed in v10.5 fp7
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
29.07.2015
24.01.2016
24.01.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.7 FixList