17.05 - ITERATE label_name - Advanced SQL Engine - Teradata Database
Teradata Vantage™ - SQL Data Definition Language Syntax and Examples
- Advanced SQL Engine
- Teradata Database
- Release Number
- January 2021
- Content Type
- Programming Reference
- Publication ID
- English (United States)
- Last Update
- A keyword introducing the ITERATE statement to terminate the execution of the current iteration of a labeled iteration statement, and start the next iteration.
Teradata Vantage™ - SQL Stored Procedures and Embedded SQL
- The label_name references the iteration statement with which the label is associated, and whose current iteration is to be terminated.
- The next iteration is started conditionally in WHILE or FOR, and unconditionally in LOOP and REPEAT.