SPP4043 Error at line <line>, column <column>:Undefined or unusable host variable <name> - 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

SPP4043 Error at line <line>, column <column>:Undefined or unusable host variable <name>

Language:

C, COBOL, PL/I

Possible Cause:

Variable has not been declared or is of a type not recognized by the precompiler as valid.

Possible Solution:

Check the precompiler listing for the variable. If it is not there, the name has not been declared in the program (or if C, not within a BEGIN/END DECLARE SECTION). If it is flagged invalid, check the variable definition.