DB2 - Problembeschreibung
Problem IT03056 | Status: Geschlossen |
TRANSLATE BUILT-IN FUNCTION FAILS WITH SQLSTATE 57017 ON UNICODE DATABASE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
On a unicode database, the built-in function SYSIBM.TRANSLATE may fail with SQLSTATE 57017 when the arguments are a mix of graphic and FOR BIT DATA strings. For example, the following usage should return CHAR(10) but fails with SQLSTATE 57017: SYSIBM.TRANSLATE( CHAR(10), VARCHAR(10) FOR BIT DATA, GRAPHIC(10) ) | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 10.1 fix pack 5 * **************************************************************** | |
Local-Fix: | |
Cast the graphic arguments to non-graphic | |
Lösung | |
First fixed in DB2 version 10.1 fix pack 5 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 09.07.2014 13.07.2015 13.07.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.5 |