SAP Knowledge Base Article - Preview

2583804 - SAP IQ - "Unable to implicitly convert column" error when you execute an "insert ~ select ~" statement with IQ 16.x


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.



SAP IQ 16.x


SAP IQ 16.0 ; SAP IQ 16.1


"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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.