Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 11.0.1 » SQL Anywhere Server - Database Administration » Configuring Your Database » 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.

Allowed values

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

Default

6

Scope

Can be set for the PUBLIC group only. Takes effect immediately.

Remarks

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

See also
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1