SPP4046 Error at line <line>, column <column>:<name> names an unusable host variable structure - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 (SPP Prefix) Messages

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Lake
Product
Preprocessor2 for Embedded SQL
Release Number
15.xx, 16.xx, 17.xx, 20.xx
Published
June 2020
ft:locale
en-US
ft:lastEdition
2023-11-20
lifecycle
Latest
Product Category
Teradata Tools and Utilities

SPP4046 Error at line <line>, column <column>:<name> names an unusable host variable structure

Language:

C, COBOL, PL/I

Possible Cause:

An unusable host structure (one which contains invalid host variable definitions or is an indicator array) was referenced in an SQL statement.

Possible Solution:

Indicator arrays may only be used with a host structure on output. If the host structure is not an indicator array, verify the definitions of the variables within the structure. Correct as possible or eliminate reference to the host structure.