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
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.