ITERATE Usage Notes - Teradata VantageCloud Lake
Lake - Working with SQL
- Deployment
- VantageCloud
- Edition
- Lake
- Product
- Teradata VantageCloud Lake
- Release Number
- Published
- February 2025
- ft:locale
- en-US
- ft:lastEdition
- 2025-11-21
- dita:mapPath
- jbe1714339405530.ditamap
- dita:ditavalPath
- pny1626732985837.ditaval
- dita:id
- jbe1714339405530
- You can use ITERATE only with a FOR, LOOP, REPEAT, or WHILE iteration statement.
- A statement label must follow the ITERATE keyword immediately.
- ITERATE statement cannot reference the label associated with the BEGIN END compound statement within which the ITERATE is embedded.
- The statement label must be associated with the iteration statement within which the ITERATE is embedded.
- If an ITERATE inside nested FOR loops refers to a label associated with an outer iteration statement, all cursors opened within the outer iteration statement are closed before performing the next iteration.