SAP Knowledge Base Article - Preview

2793832 - LOAD TABLE treats spaces as zeroes when loading NUMERIC(19,0) or larger - SAP IQ


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 


SAP IQ 16.0 ; SAP IQ 16.1


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.