Symptom
In below SQL scripts, Insert SQL encounters Datatype conversion error in IQ16 version, comparing to well working in IQ15.4.
Create table test2 (nm char(20)) ;
Select NULL into #results ;
Insert into test2 select * from #results ;
[ Error MSG ]
....
.. Exception Thrown from dflib/df_Heap.cxx:13307, Err# 72, tid 3 origtid 3
.. O/S Err#: 0, ErrID: 4098 (db_sqlexception); SQLCode: -1000187, SQLState: 'QCB87', Severity: 14
.. [20847]: Unable to implicitly convert column 'nm' to datatype (char) from datatype (smallint).-- (dflib/df_Heap.cxx 13307)
Read more...
Environment
SAP IQ16
Product
Keywords
'Select INTO', Explicit Conversion, , KBA , BC-SYB-IQ , Sybase IQ , 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.