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

Scope

Can be set only for PUBLIC.

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

See also

“PRECISION option”

For queries on the IQ store, see “MAX_CLIENT_NUMERIC_SCALE option.”