Depending on the CONVERSION_ERROR option setting, SAP Sybase IQ reports data type conversion errors as either errors, or warnings.
In releases earlier than 16.0 SP2, SAP Sybase IQ silently truncated the results when converting from TINYINT, SMALLINT, INT, DOUBLE, DATE, DATETIME, TIME, BIGINT, UNSIGNED BIGINT, and UNSIGNED INT to CHAR or VARCHAR.
If a problem occurs when converting these data types in 16.0 SP2, SAP Sybase IQ logs the failure as an error or warning in the .iqmsg file. If the CONVERSION_ERROR option is ON, SAP Sybase IQ reports the problem as an error. If the CONVERSION_ERROR option is OFF, the problem is reported as a warning.
See this topic in the SAP Sybase IQ 16.0 SP2 documentation:
CONVERSION_ERROR Option [TSQL] in Reference: Statements and Options