Rules for SQL Statements within a FOR Loop - 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ā¢
- You can specify all DML statements, including CALL, positioned UPDATE and positioned DELETE.
- You can specify all control statements.
- Transaction statements are allowed only in read-only cursors. They cannot be specified in updatable cursors.
- Each local variable, parameter, column, correlation name, or status variable referenced in the SQL statement must have been previously declared.