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 IT08680 Status: Geschlossen

SYSIBM.LEFT & SYSIBM.RIGHT MAY RETURN SQL0138N WHEN THE LENGTH CONSTANT
EXPRESSED IN STRING UNITS EXCEEDS STRING LENGTH

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
SYSIBM.LEFT( string, length contant, string unit ) returns 
SQLCODE -138, SQLCODE 22011 when length constant expressed in 
string units exceeds string length.  This APAR fix will allow 
length to exceed string length, the result is padded with blank 
characters up to the length.  The length argument must be a 
constant and the length expressed in the specified string units 
mustn't exceed the maximum size of the result data type.  The 
result data type will have a length equal to the length argument 
expressed in the specified string units.  For example: 
 
values left('abc',10,codeunits16) 
 
1 
-------------------- 
abc 
 
  1 record(s) selected. 
 
the result data type is VARCHAR(20). 
 
The same applies to SYSIBM.RIGHT.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.5 fix pack 6                       * 
****************************************************************
Local-Fix:
Cast the string argument to a larger size, or convert length to 
the default string unit of the input string and omit the string 
unit, e.g.: 
 
values left(varchar('abc',20),10,codeunits16) 
values left('abc',20)
Lösung
First fixed in DB2 version 10.5 fix pack 6
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
01.05.2015
25.08.2015
25.08.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.6 FixList