CLI based application using SQLGetData against NFM zos systems
can get extra characters causing the data retreived to be
interpretted incorrectly.
The problem is caused by a second call to SQLGetData passing
cbValueMax=0 when the call wasn't necessary. This is done before
the actual SQLGetData call with the actual required length of
data being retreived.
SQLGetData( hStmt=1:2, iCol=1,fCType=SQL_C_CHAR,
rgbValue=&00e1d4d7, cbValueMax=0,
pcbValue=&00e1d498 )
---> Time elapsed - +3.859000E-003 seconds
SQLGetData( rgbValue="" - x'', pcbValue=2527 )
<--- SQL_SUCCESS_WITH_INFO Time elapsed - +7.118400E-002
seconds
SQLGetData( hStmt=1:2, iCol=1,fCType=SQL_C_CHAR,
rgbValue=&00e1d45b, cbValueMax=0,
pcbValue=&00e1d45c )
---> Time elapsed - +6.944000E-003 seconds
( Unretrieved error message="[IBM][CLI Driver] CLI0002W Data
truncated.SQLSTATE=01004" )
SQLGetData( rgbValue="" - x'',pcbValue=2527 )
<--- SQL_SUCCESS_WITH_INFO Time elapsed - +1.023330E-001
seconds
with real value of cbValueMax:
SQLGetData( hStmt=1:2, iCol=1,fCType=SQL_C_CHAR,
rgbValue=&01b24af0, cbValueMax=32768,pcbValue=&01a2aa98 )
---> Time elapsed - +8.312000E-003 seconds
( Unretrieved error message="[IBM][CLI Driver] CLI0002W Data
truncated. SQLSTATE=01004" ) |
