Nested stored procedure with dynamic result set returns errors [CR 401334]

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 IQ server is version 12.5

• DBISQL Java connects through iAnywhere JDBC driver

• DBISQL Java version is higher than 7.04.

The problem doesn’t happen if DBSIQL Java connects through jConnect5 or the ODBC driver or if Sybase IQ 12.6 is used with DBISQL 9.0.1.

There are several ways to avoid the problem:

• Connect DBISQL Java through jConnect5 or ODBC driver.

• Use Sybase IQ 12.6 with DBISQL version 9.0.1 or use 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;