SAP Knowledge Base Article - Preview

2144187 - Select Into & Implicit Datatype conversion Error -- SAP IQ 16

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

SAP IQ 16.0

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.