-303 Incompatible host variable and returned data - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 (SPP Prefix) Messages

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Preprocessor2 for Embedded SQL
Release Number
15.xx, 16.xx, 17.xx, 20.xx
Published
June 2020
Language
English (United States)
Last Update
2023-11-20
lifecycle
Latest
Product Category
Teradata Tools and Utilities

-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 the 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.