17.10 - PREPARE - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)

An SQL_statement_name is to be set up to be executed dynamically.

The PREPARE statement is valid only for result set cursors.

See Teradata Vantage™ - SQL Stored Procedures and Embedded SQL, B035-1148 for details.

SQL_string
The SQL text that is to be executed dynamically.
SQL_string must be delimited by APOSTROPHE characters.
SQL_string_variable
Name of an SQL local variable that contains the SQL text string that is to be executed dynamically.