Contents Index PINNED_CURSOR_PERCENT_OF_CACHE option [database] PREFETCH option [database]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

PRECISION option [database]


Function 

Specifies the maximum number of digits in the result of any decimal arithmetic.

Allowed values 

Integer, between 0 and 127 inclusive.

Scope 

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

Default 

30

Description 

Precision is the total number of digits to the left and right of the decimal point. The SCALE option [database] specifies 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 will be kept in the result. If SCALE is 4, the result will be a DECIMAL(15,4). If SCALE is 2, the result will be a DECIMAL(15,2). In both cases, there is a possibility of overflow.


Contents Index PINNED_CURSOR_PERCENT_OF_CACHE option [database] PREFETCH option [database]