15.00 - -822 The SQLDA contains an invalid data address - Teradata Tools and Utilities

Teradata Preprocessor2 (SPP Prefix) Messages

prodname
Teradata Tools and Utilities
vrm_release
15.00
category
Programming Reference
featnum
B035-1096-015K

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