SPP4013 Warning, Statement beginning at line <line>:Host variable <name> is the wrong type to receive column <column> - 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

SPP4013 Warning, Statement beginning at line <line>:Host variable <name> is the wrong type to receive column <column>

Language:

C, COBOL, PL/I

Possible Cause:

The host variable is an incompatible type which will cause an execution time error. Numeric data (with the exception of DATEs) may only be returned to numeric host variables. Character type data may only be returned to a character type host field.

Possible Solution:

Check the precompiler listing to see what the type of the receiving variable was as used by the precompiler. Change the host variable declaration to a legal receiving type.