SCALE 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 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.

Related reference
MAX_CLIENT_NUMERIC_SCALE Option
PRECISION Option