DB2 - Problembeschreibung
Problem IC87917 | Status: Geschlossen |
SQLDESCRIBEPARAM() MAY FAIL WITH CLI0150E DRIVER NOT CAPABLE WHEN CALLING AN UNQUALIFIED STORED PROCEDURE ON DB2 FOR Z/OS | |
Produkt: | |
DB2 CONNECT / DB2CONNCT / A10 - DB2 | |
Problembeschreibung: | |
When calling SQLDescribeParam() on a prepared statement for a stored procedure running on DB2 for z/OS, it may fail with the following error: [IBM][CLI Driver] CLI0150E Driver not capable. SQLSTATE=HYC00 Stored procedures are qualified by adding the name of the schema along with the stored procedure name. When the schema name is not provided, it should qualify it with the connecting userid as the default schema. The failure occurs when the stored procedure is called without the schema name and the stored procedure exists under the connecting userid's schema. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * If a stored procedure is called without qualifying, the * * stored procedure may fail with 'Driver not capable ' error. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to product version v.97.fp7 * **************************************************************** | |
Local-Fix: | |
When calling the stored procedure, ensure it is explicitly qualified with the schema name. For example, "call schema.storedprocedure()" instead of "call storedprocedure()" | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 04.11.2012 18.12.2012 18.12.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.2 | |
10.5.0.2 |