SAP Knowledge Base Article - Preview

3300243 - The number of decimal places differs between IQ 15.x and 16.1 - SAP IQ

Symptom

When a column 'col1' has value '0', the number of decimal places returns differently by the below query:

  • IQ 15.x returns 5 digits:
    select col1 / 1000 from test
    test.col1/1000;
    --------------
    0.00000
    (1 rows)
  • IQ 16.1 returns 6 digits.
    select col1 / 1000 from test
    test.col1/1000;
    --------------
    0.000000
    (1 rows)


Read more...

Environment

  • SAP IQ 16.0 SP10 and later
  • SAP IQ 16.1

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

MIN_NUMERIC_DIVISION_SCALE , 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 for Me (Login required).

Search for additional results

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