MAX_CLIENT_NUMERIC_PRECISION option

Function

Controls the maximum precision 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 size that ensures accuracy. The promoted data type might be larger in size than Open Client and some ODBC applications can handle correctly.

When MAX_CLIENT_NUMERIC_PRECISION is a nonzero value, Sybase IQ checks that numeric result columns do not exceed this value. If the result column is bigger than MAX_CLIENT_NUMERIC_PRECISION allows, and Sybase IQ is unable to cast it to the specified precision, the query returns the error:

Data Exception - data type conversion is not possible %1
SQLCODE = -1001006

See also

“MAX_CLIENT_NUMERIC_SCALE option”.

To control precision for queries on the Catalog Store, see “PRECISION option”.