SQL Statements › CREATE PROCEDURE › CREATE PROCEDURE Syntax and Description › ITERATE Statement

ITERATE Statement

The ITERATE statement controls looping logic in a compound statement. Use the ITERATE statement to specify when to skip to the next iteration of a loop.

Following is the syntax for the ITERATE statement:

►►─ ITERATE ─ statement-label ────────────────────────────────────────────────►◄

statement-label

The statement-label specifies the start-label of a loop, that is, it relates the ITERATE statement to the position at which execution continues.