MAX_CLIENT_NUMERIC_PRECISION Option

0 – 126

0

Option can be set at the database (PUBLIC) or user level. At the database level, the value becomes the default for any new user, but has no impact on existing users. At the user level, overrides the PUBLIC value for that user only. No system privilege is required to set option for self. System privilege is required to set at database level or at user level for any user other than self.

Requires the SET ANY PUBLIC OPTION system privilege to set this option. Can be set temporary for an individual connection or for the PUBLIC role. Takes effect immediately.

When SAP 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, SAP IQ checks that numeric result columns do not exceed this value. If the result column is bigger than MAX_CUBE_RESULT allows, and SAP IQ cannot cast it to the specified precision, the query returns this error:

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