LOAD TABLE should give a conversion error when the source data is a space and the target column is NUMERIC. However, if the scale of the NUMERIC is 19 or higher, a value of 0 is loaded.
When the source value is a space, but only when the scale of the NUMERIC is 19 or higher, LOAD TABLE inserts value of 0 into a NUMERIC column. But If the scale of the NUMERIC is less than 19 then a "Cannot convert to numeric" error is raised (as expected). The same error is raised for DECIMAL, except the error is "Cannot convert to Unknown TypeID" INSERT returns the "Cannot convert" error regardless of scale.
- SAP IQ 16
- SAP IQ 16.1
KBA , BC-SYB-IQ , Sybase IQ , Problem
About this pageThis 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.