SCALE option

Function

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.

Allowed values

Integer, with a maximum of 126.

Default

38

Description

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 can all have results that exceed the maximum precision.

See also

“PRECISION option”

For queries on the IQ Store, see “MAX_CLIENT_NUMERIC_SCALE option”