DB2 - Problembeschreibung
Problem IC85491 | Status: Geschlossen |
SQLSTATE RETURNED FOR MISSING TABLE/VIEW IS INCORRECT ? RETURNS D42S22 (COLUMN NOT FOUND) INSTEAD OF D42S02 (TABLE NOT FOUND). | |
Produkt: | |
DB2 CONNECT / DB2CONNCT / 970 - DB2 | |
Problembeschreibung: | |
In case of Informix Server (IDS) when trying through cli driver on a query of invalid table , scenarios like table no present when tried to drop table. When tried to create index on a table which is not present it should return error S0002 but it was returning error code S0022 which is for invalid columns in case of db2 . | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * When CLI driver is used against Informix Server. * **************************************************************** * PROBLEM DESCRIPTION: * * In case of Informix Server (IDS) when trying through cli * * driver * * on a query of invalid table , scenarios like table no * * present * * when tried to drop table. When tried to create index on a * * table * * which is not present it should return error S0002 but it was * * returning error code S0022 which is for invalid columns in * * case * * of db2 . * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V9.7 FP7 or later releases. * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows | |
Lösung | |
DB2 V9.7 Fix Pack 7 contains fix of this issue. After the fix, CLI driver returns correct error message. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 24.07.2012 30.08.2014 30.08.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP7 | |
Problem behoben lt. FixList in der Version | |
9.7.0.7 |