Declares the names used to identify prepared dynamic SQL statements.
ANSI Compliance
DECLARE STATEMENT is a Teradata extension to the ANSI/ISO SQL:2011 standard.
Required Privileges
None.
Invocation
Nonexecutable preprocessor declaration.
Embedded SQL only.
Syntax
DECLARE statement_name [,...] STATEMENT
Syntax Elements
- statement_name
- The name associated with a previously prepared statement.
Usage Notes
DECLARE STATEMENT is used for program documentation only.