MAX_CLIENT_NUMERIC_SCALE option

Function

Controls the maximum scale for numeric data sent to the client.

Allowed values

0 – 126

Default

0

Scope

Can be set by any user, at any level. This option takes effect immediately.

Description

When Sybase IQ performs its calculation, it promotes data types to an appropriate scale and size that ensure accuracy. The promoted data type might be larger than the original defined data size. You can set this option to the scale you want for numeric results.

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

For example, when a DECIMAL(88,2) is multiplied with a DECIMAL(59,2), the result could require a DECIMAL(147,4). With MAX_CLIENT_NUMERIC_PRECISION of 126, only 126 digits are kept in the result. If MAX_CLIENT_NUMERIC_SCALE is 4, the results are returned as a DECIMAL(126,4). If MAX_CLIENT_NUMERIC_SCALE is 2, the result are returned as a DECIMAL(126,2). In both cases, there is a possibility for overflow.

See also

“MAX_CLIENT_NUMERIC_PRECISION option”

To control scale for queries on the catalog store, see “SCALE option”