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

Syntax

{ ulcreate | ulinit | ulload } -o scale=value;...

Allowed values

Integer, between 0 and 127, inclusive

Default

6

Remarks

The position of the decimal point is determined by the precision and the scale of the number: precision is the total number of digits to the left and right of the decimal point; scale is the minimum number of digits after the decimal point when an arithmetic result is truncated to the maximum precision.

Choosing an appropriate decimal point position is typically determined by:

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

From Sybase Central, you can set the scale in any wizard that creates a database. On the New database creation parameters page, select the Scale option.

From a client application, set this parameter as one of the creation parameters for the create database method on the database manager class.

See also

• UltraLite precision creation parameter
• UltraLite Create Database utility (ulcreate)
• UltraLite Initialize Database utility (ulinit)
• UltraLite Load XML to Database utility (ulload)
• UltraLite for embedded SQL: ULCreateDatabase function
• UltraLite for C++: CreateDatabase function
• UltraLite.NET: CreateDatabase method
• UltraLite for M-Business Anywhere: createDatabase method
• Accessing creation parameter values

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 a DECIMAL(15,2). In both cases, there is a possibility of overflow.