PREPARE Syntax Elements - Teradata Vantage - Analytics Database
SQL Stored Procedures and Embedded SQL
- Deployment
- VantageCloud
- VantageCore
- Edition
- VMware
- Enterprise
- IntelliFlex
- Product
- Analytics Database
- Teradata Vantage
- Release Number
- 17.20
- Publication Date
- June 2022
- Content Type
- SQL Reference
- Publication ID
- B035-1148-172K
- ft:locale
- en-US
- ft:lastEdition
- 2023-10-30
- dita:mapPath
- frc1628111662093.ditamap
- dita:ditavalPath
- qkf1628213546010.ditaval
- ft:sourceId
- dita
- dita:id
- rjx1472253414573
- lifecycle
- latest
- 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.