-822 The SQLDA contains an invalid data address - 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

-822 The SQLDA contains an invalid data address

Possible Cause

The SQLDATA field of the referenced SQLDA structure has not been assigned a host variable address. This error occurs if the value in the SQLDATA field is hex zeros (all languages) or a PL/I null (x FF000000 ).

Possible Solution

The precompiler generates the SQLDA structures required for a request and assigns the addresses. Verify that the application has not overwritten the SQLDA structure and that the precompiler-generated code is correct. If this is a dynamic SQLDA, verify that this field is assigned an address prior to using the SQLDA in the request.