|
Problem IC92226
|
Status: Geschlossen |
CLI0143E ON SQLBINDPARAMETER FOR TIMESTAMP TYPE WITH CBCOLDEF=-1 |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All DB2 CLI users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* upgrade to DB2 v101 fp3 or later *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
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
|
| Lösung |
Problem fixed in DB2 v101 fp3 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 10.05.2013
07.10.2013
07.10.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
