DB2 - Problembeschreibung
Problem IC82230 | 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 / 970 - 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: * * SQLDESCRIBEPARAM() MAY FAIL WITH CLI0150E DRIVER NOT CAPABLE * * WHEN CALLING AN UNQUALIFIED STORED PROCEDURE ON DB2 FOR Z/OS * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 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 9.7 Fix Pack 7 for Linux, UNIX, and Windows | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC87917 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 23.03.2012 31.10.2012 31.10.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
9.7.0.7 |