Controls the maximum precision for numeric data sent to the client.
0 – 126
0
Can be set by any user, at any level. This option takes effect immediately.
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
“MAX_CLIENT_NUMERIC_SCALE option”.
To control precision for queries on the Catalog Store, see “PRECISION option”.
