IBM Support

IC92226: CLI0143E ON SQLBINDPARAMETER FOR TIMESTAMP TYPE WITH CBCOLDEF=-1

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • After upgrading the client from v9.1 or v9.5 to version v9.7 or
    v10.1 a CLI application can report CLI0143E during execution of
    the API SQLBindParameter for the type TIMESTAMP if a value for
    cbColDef is  -1.
    
    
    Here is reproduction testscript (inout for db2cli.exe executable
    located under <instpath>\BIN:
    
    opt calldiag on
    opt echo on
    quickc 1 1 sample
    
    SQLAllocStmt 1 1
    
    getmem 1 1  SQL_C_TYPE_TIMESTAMP
    getmem 1 2  SQL_C_TYPE_TIMESTAMP
    
    updatemem 1 SQL_C_TIMESTAMP value 2004 05 18 12 31 57 000000000
    updatemem 2 SQL_C_TIMESTAMP NULL_VALUE
    
    SQLBindParameter 1 1 SQL_PARAM_INPUT SQL_C_TIMESTAMP
    SQL_TYPE_TIMESTAMP 16 0 1
    SQLBindParameter 1 2 SQL_PARAM_INPUT SQL_C_TIMESTAMP
    SQL_TYPE_TIMESTAMP -1 0 2
    
    Last statement in the script is failing with error:
    
    > SQLBindParameter 1 2 SQL_PARAM_INPUT SQL_C_TIMESTAMP
    SQL_TYPE_TIMESTAMP -1 0 2
    
    SQLBindParameter 1 2 SQL_PARAM_INPUT SQL_C_TIMESTAMP
    SQL_TYPE_TIMESTAMP -1 0 2
    SQLBindParameter: rc = -1 (SQL_ERROR)
    SQLError: rc = 0 (SQL_SUCCESS)
    SQLGetDiagRec: SQLState     : S1104
              fNativeError : -99999
              szErrorMsg   : [IBM][CLI Driver] CLI0143E  Invalid
    precision value. SQLSTATE=S1104
              cbErrorMsg   : 67
    >
    
    The same testcript completes without error when using v9.1 and
    v9.5 client.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All DB2 CLI users                                            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * upgrade to DB2 v101 fp3 or later                             *
    ****************************************************************
    

Problem conclusion

  • Problem fixed in DB2 v101 fp3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC92226

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-05-10

  • Closed date

    2013-10-07

  • Last modified date

    2013-10-07

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

    IC90562

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RA10 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
07 October 2013