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 cannot cast it to the specified precision, the query returns this error:
Data Exception - data type conversion is not possible %1 SQLCODE = -1001006
In SQL Anywhere, the maximum value supported for the numeric function
is 255. If the precision of the numeric function exceeds the maximum value
supported, you see this error: The result datatype
for function '_funcname' exceeds the maximum supported
numeric precision of 255. Please set the proper value for precision
in numeric function, 'location'
“MAX_CLIENT_NUMERIC_SCALE option”
To control precision for queries on the catalog store, see “PRECISION option”
