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

DECODE FUNCTION USES UNEXPECTED BLANK-PADDED COMPARISON FOR FIX-LENGTH
STRING EXPRESSIONS IN VARCHAR2 COMPATIBILITY MODE

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
When using the DECODE function in VARCHAR2 compatibility mode, 
the fix-length string expressions are compared using 
blank-padded comparison, which is unexpected. 
 
Here is an example: 
 
db2set DB2_COMPATIBILITY_VECTOR=20 
db2stop 
db2start 
db2 create db sample 
db2 connect to sample 
db2 create table t1 (c1 char(13)) 
db2 insert into t1 values('ABCDEFG') 
 
db2 "SELECT '---'||DECODE('1','1         ','ABC', 'DEF') || 
'---'  FROM t1" 
 
   output:    ---ABC--- 
 
Expected output is: ---DEF---
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* When using the DECODE function in VARCHAR2 compatibility     * 
* mode, the fix-length string expressions are compared using   * 
* blank-padded comparison, which is unexpected.                * 
*                                                              * 
* Here is an example:                                          * 
*                                                              * 
* db2set DB2_COMPATIBILITY_VECTOR=20                           * 
* db2stop                                                      * 
* db2start                                                     * 
* db2 create db sample                                         * 
* db2 connect to sample                                        * 
* db2 create table t1 (c1 char(13))                            * 
* db2 insert into t1 values('ABCDEFG')                         * 
*                                                              * 
* db2 "SELECT '---'||DECODE('1','1        ','ABC', 'DEF') ||   * 
* '---'  FROM t1"                                              * 
* output:    ---ABC---                                         * 
* Expected output is: ---DEF---                                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 Fix Pack 4 or later.                     * 
****************************************************************
Local-Fix:
Cast the first parameter of DECODE function to VARCHAR.
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Issue first fixed in DB2 V9.7 Fix Pack 4
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
04.06.2010
09.05.2011
09.05.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP4
Problem behoben lt. FixList in der Version
9.7.0.4 FixList