-504 Referenced item has not been declared or prepared - 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

-504 Referenced item has not been declared or prepared

Possible Cause

The referenced dynamic statement has not been successfully prepared prior to the current request. This error may be returned for a DESCRIBE or EXECUTE request. Dynamic statements become unprepared when a commit or rollback occurs.

Possible Solution

Ensure the dynamic statement is prepared before attempting the reference.