PREPARE Syntax Elements - Teradata Vantage
Teradata® VantageCloud Lake
- Deployment
- VantageCloud
- Edition
- Lake
- Product
- Teradata Vantage
- Published
- January 2023
- ft:locale
- en-US
- ft:lastEdition
- 2024-12-11
- dita:mapPath
- phg1621910019905.ditamap
- dita:ditavalPath
- pny1626732985837.ditaval
- dita:id
- phg1621910019905
- statement_name
- The name to be associated with the prepared statement.
- statement_name must be a valid SQL identifier and must not be enclosed within apostrophes.
- descriptor_area
- Specifies the SQLDA to receive the descriptive information about the data returned when the prepared statement is run.
- You can specify descriptor_area in C programs as a name or as a pointer reference (*sqldaname) when the SQLDA structure is declared as a pointer.
- statement_string
- The text of the dynamic SQL statement or statements as a string expression.
- statement_string_variable
- The dynamic SQL statement text as a host variable.
- The colon before statement_string_variable is optional.
- statement_number
- A valid integer literal that identifies the statement number within the request for which the descriptive information is requested
- numeric_variable
- A host variable of type INTEGER or SMALLINT that represents the statement number in the request for which the descriptive information is requested.
- The preceding colon is optional.