PREPARE Syntax Elements - Advanced SQL Engine - Teradata Database
SQL Stored Procedures and Embedded SQL
- Product
- Advanced SQL Engine
- Teradata Database
- Release Number
- 17.10
- Published
- July 2021
- Language
- English (United States)
- Last Update
- 2021-07-28
- dita:mapPath
- vqj1592443206677.ditamap
- dita:ditavalPath
- vqj1592443206677.ditaval
- dita:id
- B035-1148
- lifecycle
- previous
- Product Category
- Teradata Vantage™
- 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 executed.
- 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.