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 jConnect5 or 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 jConnect5 or ODBC driver.

• Use 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;