Data truncation or data conversion error

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 Java connects through iAnywhere JDBC driver

• dbisql Java version is higher than 7.04.

The problem does not happen if dbisql Java 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.

There are several ways to avoid the problem:

• Connect dbisql Java through the ODBC driver.

• Use:

  • Sybase IQ 15.1 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;