If you are updating from an earlier release of SAP Sybase IQ, the truncation behavior and maximum values of
some database options has changed in release 16.0 SP2.
CONVERSION_ERROR Option
Depending on the CONVERSION_ERROR option setting, SAP Sybase IQ reports data type conversion errors as either errors, or warnings.
JOIN_SIMPLIFICATION_THRESHOLD Option
The maximum allowed value of the JOIN_SIMPLIFICATION_THRESHOLD database option has changed to 24 in SAP Sybase IQ release 16.0 SP2.
MAX_JOIN_ENUMERATION Option
The maximum allowed value of the MAX_JOIN_ENUMERATION database option has changed to 32 in SAP Sybase IQ release 16.0 SP2.