DB2 CONNECT / DB2CONNCT / 970 - DB2

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.

**************************************************************** 
* 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                                          * 
****************************************************************

When calling the stored procedure, ensure it is explicitly 
qualified with the schema name.  For example, "call 
schema.storedprocedure()" instead of "call storedprocedure()"

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
 

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC87917 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

23.03.2012
31.10.2012
31.10.2012