Controls the maximum precision 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 size that ensures accuracy. The promoted data type may be larger than Open Client and some ODBC applications can handle correctly.
When MAX_CLIENT_NUMERIC_PRECISION is a non-zero value, IQ checks that numeric result columns do not exceed this value. If the result column is bigger than MAX_CLIENT_NUMERIC_PRECISION allows, and 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
“MAX_CLIENT_NUMERIC_SCALE option”
To control precision for queries on the Catalog Store, see “PRECISION option”
