|
Problem IC92226
|
Status: Closed |
CLI0143E ON SQLBINDPARAMETER FOR TIMESTAMP TYPE WITH CBCOLDEF=-1 |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem 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. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All DB2 CLI users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* upgrade to DB2 v101 fp3 or later *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
Problem fixed in DB2 v101 fp3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.05.2013
07.10.2013
07.10.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
