Specifies the minimum number of digits after the decimal point when an arithmetic result is truncated to the maximum PRECISION, for queries on the catalog store only.
Integer, with a maximum of 126.
38
Can be set only for PUBLIC.
This option specifies the minimum number of digits after the decimal point when an arithmetic result is truncated to the maximum PRECISION, for queries on the catalog store.
Multiplication, division, addition, subtraction, and aggregate functions may all have results that exceed the maximum precision.
For queries on the IQ store, see “MAX_CLIENT_NUMERIC_SCALE option.”