Rules for FOR-Loop Variables - 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™
- FOR loop variable names must be unique if they are used in nested FOR iteration loops.
- FOR loop variable names can be the same as the cursor name and correlation names within a FOR iteration statement.
- If you use a FOR loop variable in an SQL statement other than a control statement within the iteration statement, you must prefix it with a colon character (:).
- Unqualified symbols in a FOR loop are assumed to be variable or parameter names.