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

Search for additional results

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