Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite Database Settings Reference » Configurable properties in UltraLite

UltraLite page_size property Next Page

UltraLite precision property


Specifies the maximum number of digits in decimal point arithmetic results.

How to set it

UltraLite employs different methods for setting this property:

ContextImplemented by

From the command line    Use any utility that creates a database.

Use the following property syntax:

-o precision=value

From Sybase Central    Use any wizard that creates a database.

On the New Database Options page, set the Precision option .

From a client application    Use the create database method.

Set this property as one of the creation parameters for an API's create database method on the database manager class.

Allowed values

Integer, between 1 and 127, inclusive

Default

30

Remarks

The precision is the total number of digits to the left and right of the decimal point. Use this property with the scale property to specify the minimum number of digits after the decimal point when an arithmetic result is truncated to the maximum precision.

Multiplication, division, addition, subtraction, and aggregate functions can all have results that exceed the maximum precision. For example, when a DECIMAL(8,2) is multiplied with a DECIMAL(9,2), the result could require a DECIMAL(17,4). If precision is 15, only 15 digits are kept in the result. If scale is 4, the result is DECIMAL(15,4). If scale is 2, the result is DECIMAL(15,2). In both cases, there is a possibility of overflow.

You cannot change the precision of an existing database. Instead, you must create a new database.

If you are using an Oracle database as a consolidated database, all UltraLite remotes and the Oracle consolidated databases must share the same precision value.

See also