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

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.

Environment

SAP IQ 16.x

Product

SAP IQ 16.0 ; SAP IQ 16.1

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.