When taking a CLI trace of an application, the application
buffer holding the column value or parameter marker value may be
empty if the application sets the cbValueMax value to 0.
For example, the following CLI trace snippet shows the problem:
[11/18/2009 18:51:11.702023] SQLBindParameter( hStmt=1:1,
iPar=1, fParamType=SQL_PARAM_INPUT, fCType=SQL_C_CHAR,
fSQLType=SQL_CHAR, cbColDef=3, ibScale=0, rgbValue=&0012fb18,
cbValueMax=3, pcbValue=&0012ff68 )
[11/18/2009 18:51:11.719392] ---> Time elapsed - +1.720000E-003
seconds
[11/18/2009 18:51:11.721445] SQLBindParameter( )
[11/18/2009 18:51:11.723404] <--- SQL_SUCCESS Time elapsed -
+2.138100E-002 seconds
[11/18/2009 18:51:11.725410] SQLBindParameter( hStmt=1:1,
iPar=2, fParamType=SQL_PARAM_INPUT, fCType=SQL_C_CHAR,
fSQLType=SQL_CHAR, cbColDef=3, ibScale=0, rgbValue=&0012fb14,
cbValueMax=0, pcbValue=&0012ff6c )
[11/18/2009 18:51:11.745735] ---> Time elapsed - +2.006000E-003
seconds
[11/18/2009 18:51:11.747729] SQLBindParameter( )
[11/18/2009 18:51:11.749509] <--- SQL_SUCCESS Time elapsed -
+2.409900E-002 seconds
.................
[11/18/2009 18:51:11.751517] SQLExecute( hStmt=1:1 )
[11/18/2009 18:51:11.755183] ---> Time elapsed - +2.008000E-003
seconds
[11/18/2009 18:51:11.756969] ( Package="SYSSH200 ", Section=4 )
[11/18/2009 18:51:11.762341]
[11/18/2009 18:51:11.764467] ( Row=1, iPar=1, fCType=SQL_C_CHAR,
rgbValue="ABC" - x'414243', pcbValue=-3, piIndicatorPtr=-3 )
[11/18/2009 18:51:11.777222]
[11/18/2009 18:51:11.778995] ( Row=1, iPar=2, fCType=SQL_C_CHAR,
rgbValue="" - x'', pcbValue=-3, piIndicatorPtr=-3 )
[11/18/2009 18:51:11.791185]
In this case we have two parameters. The value in the first
parameter shows up fine when the statement is executed, however
the value in the second parameter does not show up fine.
The application calls the SQLBindParameter() API with a
cbValueMax value of 0 on the second parameter. When the
statement is executed, the "rgbValue" shows up as empty string.
This is not expected. |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* When taking a CLI trace of an application, the application *
* buffer holding the column value or parameter marker value *
* may be empty if the application sets the cbValueMax value to *
* 0. *
* *
* For example, the following CLI trace snippet shows the *
* problem: *
* *
* [11/18/2009 18:51:11.702023] SQLBindParameter( hStmt=1:1, *
* iPar=1, fParamType=SQL_PARAM_INPUT, fCType=SQL_C_CHAR, *
* fSQLType=SQL_CHAR, cbColDef=3, ibScale=0, *
* rgbValue=&0012fb18, cbValueMax=3, pcbValue=&0012ff68 ) *
* [11/18/2009 18:51:11.719392] ---> Time elapsed - *
* +1.720000E-003 seconds *
* *
* *
* [11/18/2009 18:51:11.721445] SQLBindParameter( ) *
* [11/18/2009 18:51:11.723404] <--- SQL_SUCCESS Time elapsed - *
* +2.138100E-002 seconds *
* *
* *
* [11/18/2009 18:51:11.725410] SQLBindParameter( hStmt=1:1, *
* iPar=2, fParamType=SQL_PARAM_INPUT, fCType=SQL_C_CHAR, *
* fSQLType=SQL_CHAR, cbColDef=3, ibScale=0, *
* rgbValue=&0012fb14, cbValueMax=0, pcbValue=&0012ff6c ) *
* [11/18/2009 18:51:11.745735] ---> Time elapsed - *
* +2.006000E-003 seconds *
* *
* *
* [11/18/2009 18:51:11.747729] SQLBindParameter( ) *
* [11/18/2009 18:51:11.749509] <--- SQL_SUCCESS Time elapsed - *
* +2.409900E-002 seconds *
* *
* ................. *
* *
* *
* [11/18/2009 18:51:11.751517] SQLExecute( hStmt=1:1 ) *
* [11/18/2009 18:51:11.755183] ---> Time elapsed - *
* +2.008000E-003 seconds *
* [11/18/2009 18:51:11.756969] ( Package="SYSSH200 ", *
* Section=4 ) *
* [11/18/2009 18:51:11.762341] *
* [11/18/2009 18:51:11.764467] ( Row=1, iPar=1, *
* fCType=SQL_C_CHAR, rgbValue="ABC" - x'414243', pcbValue=-3, *
* piIndicatorPtr=-3 ) *
* [11/18/2009 18:51:11.777222] *
* [11/18/2009 18:51:11.778995] ( Row=1, iPar=2, *
* fCType=SQL_C_CHAR, rgbValue="" - x'', pcbValue=-3, *
* piIndicatorPtr=-3 ) *
* [11/18/2009 18:51:11.791185] *
* *
* In this case we have two parameters. The value in the first *
* parameter shows up fine when the statement is executed, *
* however the value in the second parameter does not show up *
* fine. *
* *
* The application calls the SQLBindParameter() API with a *
* cbValueMax value of 0 on the second parameter. When the *
* statement is executed, the "rgbValue" shows up as empty *
* string. *
* *
* This is not expected. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Version 9.1 Fix Pack 10. *
**************************************************************** |
