Controls the maximum scale for numeric data sent to the client.
0 to 126
Can be set by any user, at any level. This option takes effect immediately.
0
When Sybase IQ performs it calculation, it promotes data types to an appropriate scale and size that ensure accuracy. The promoted data type may 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 will be kept in the result. If MAX_CLIENT_NUMERIC_SCALE is 4, the result will be returned as a DECIMAL(126,4). If MAX_CLIENT_NUMERIC_SCALE is 2, the result will be returned as a DECIMAL(126,2). In both cases, there is a possibility for overflow.
“MAX_CLIENT_NUMERIC_PRECISION option”
To control scale for queries on the Catalog Store, see “SCALE option”
