15.00 - -303 Incompatible host variable and returned data - Teradata Tools and Utilities

Teradata Preprocessor2 (SPP Prefix) Messages

prodname
Teradata Tools and Utilities
vrm_release
15.00
category
Programming Reference
featnum
B035-1096-015K

-303 Incompatible host variable and returned data

Possible Cause

The data type of the referenced host variable is either invalid (input) or is incompatible with the data type of the returned data (output). For input host variables, this message is usually returned when the data type assigned by the application for a dynamic request is incorrect (the SQLTYPE field of the input SQLDA structure is invalid. See SQL Data Type Codes in Teradata Preprocessor2 for Embedded SQL Programmer Guide, for correct values. For output host variables, the data type of the variable is incorrect or the returned field may not be validly converted to the requested data type.

Possible Solution

For input, verify the SQLTYPE field is assigned correctly. For output, verify the SQLTYPE field is assigned correctly and that the data returned is compatible with the host variable type. See the passage Output Host Variables in Teradata Preprocessor2 for Embedded SQL Programmer Guide, for valid data assignments.