Previous Topic: -158 - CANNOT CREATE SYNONYM FOR INVALID VIEW aaaaNext Topic: -161 - colname datatype(prec,scale) INVALID DATA: hh

SQL Codes › SQL Return Codes -1 through -999 › -159 - HOST VARIABLE INCOMPATIBLE WITH COLUMN AT POSITION aaaa

-159 - HOST VARIABLE INCOMPATIBLE WITH COLUMN AT POSITION aaaa

Reason:

You are attempting to fetch data of a particular type into a host variable of another data type and the data cannot be converted to the data type of the host variable. The position indicated by aaaa is the position of the column in the DECLARE CURSOR column list.

The SQLSTATE that equates to this SQL return code is 42806.

Action:

First, compare the host variable list in the FETCH statement to the column list in the DECLARE CURSOR statement to ensure that the position of the columns matches the position of the host variables specified. Next, ensure that the column data type is compatible with the host variable data type.