SQL Anywhere® Server - Database Administration  > Database Options  > Introduction to database options  > Alphabetical list of options

scale option [database]

Specifies the minimum number of digits after the decimal point when an arithmetic result is truncated to the maximum precision.

Integer, between 0 and 127, inclusive, and less than the value specified for the precision database option

6

Can be set for an individual connection or for the PUBLIC group. Takes effect immediately.

Multiplication, division, addition, subtraction, and aggregate functions can all have results that exceed the maximum precision.

• precision option [database]