Previous Topic: -307 - STATEMENT-NAME statement_name CAN ONLY BE USED WITH ONE CURSORNext Topic: -309 - HOST VARIABLES CANNOT BE USED IN DYNAMICALLY PREPARED STATEMENTS

SQL Codes › SQL Return Codes -1 through -999 › -308 - PREPARE HOST VARIABLE SOURCE STATEMENT LENGTH INVALID

-308 - PREPARE HOST VARIABLE SOURCE STATEMENT LENGTH INVALID

Explanation

The length specified in the VARCHAR host variable (first two bytes) is larger than the length specified for the VARCHAR host variable in the SQLDA.

The SQLSTATE that equates to this SQL return code is 07S08.

User Response

Modify the length of the SQLDA or the VARCHAR.