Data Truncation or Data Conversion Error

Certain issues may cause data truncation or conversion errors.

Possible Causes

A data truncation error or conversion error occurs when a procedure calls another procedure with a dynamic result set and all of the following are true:

The Sybase IQ server is version 12.5
dbisql connects through iAnywhere JDBC driver
dbisql version is higher than 7.04.

The problem does not happen if dbisql connects through the ODBC driver or if Sybase IQ 12.6 is used with dbisql 9.0.1.

Differences in display characteristics between your terminal and the expectations of Sybase IQ.
Differences in function key support between your terminal and the expectations of Sybase IQ.

Actions

Connect dbisql through the ODBC driver.
Use:
- Sybase IQ 15.1 or 15.2 with dbisql version 11.0.1,
- Sybase IQ 12.7 with dbisql version 9.0.2,
- Sybase IQ 12.6 with dbisql version 9.0.1, or
- Sybase IQ 12.5 with dbisql version 7.0.4
Add a statement like the following to the start of the procedure, to keep the server from adding a result set:
```
IF 1 = 0 THEN
SELECT 1 AS a FROM nosuchtable;
END IF;
```