IBM Support

IC87917: SQLDESCRIBEPARAM() MAY FAIL WITH CLI0150E DRIVER NOT CAPABLE WHEN CALLING AN UNQUALIFIED STORED PROCEDURE ON DB2 FOR Z/OS

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • 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.
    

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()"
    

Problem summary

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

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC87917

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    A10

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-04

  • Closed date

    2012-12-18

  • Last modified date

    2012-12-18

  • APAR is sysrouted FROM one or more of the following:

    IC82230

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 10.1

Reference #: IC87917

Modified date: 18 December 2012


Translate this page: