Symptom
When you execute an "insert ~ select ~" statement with IQ 16.x version, following error occurs.
Could not execute statement.
Unable to implicitly convert column 'bb' to datatype (varchar) from
datatype (smallint).
-- (dflib/df_Heap.cxx 13689)
SQLCODE=-1000187, ODBC 3 State="HY000"
The "insert ~ select ~" statement runs fine with IQ 15.x.
Read more...
Environment
SAP IQ 16.x
Product
Keywords
"Unable to implicitly convert column"; "Unable to implicitly"; "SQLCODE=-1000187"; "-1000187"; "Conversion_Mode"; sybase, 'data type', 'df_Heap.cxx 13990', '#temp', 'temp tables', temporary, fail, smallint, upgrade , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.