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

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