SAP Knowledge Base Article - Preview

3164002 - CAST/ CONVET function outputs a conversion error from String type to NUMBER(DECIMAL) type - SAP IQ

Symptom

The CAST / CONVET function outputs a conversion error from String type to NUMBER type when the precision is insufficient.

select cast('0.7272727272727' as numeric(20,12)) from iq_dummy
Could not execute statement.
  Data type conversion is not possible. Failure converting from
  NUMERIC(20,12) for expression CAST('0.7272727272727' AS NUMERIC(20,12)).
  -- (dflib/dfe_Cast.cxx 1014)
  SQLCODE=-1009145, ODBC 3 State="HY000"


Read more...

Environment

SAP IQ all versions

Product

SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.4

Keywords

cast, conversion, numeric, decimal, string, precision, -1009145 , KBA , BC-SYB-IQ , Sybase IQ , Problem

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.