Description

label
Specifies the label for the REPEAT statement. If the ending label is specified, it must be the same as the beginning label. The label name cannot be the same as the routine name or another label within the same scope. For more information, see Handling errors and warnings.
SQL-procedure-statement
Specifies an SQL statement to be executed in the REPEAT loop.
search-condition
The search-condition is evaluated after each execution of the REPEAT loop. If the condition is true, the REPEAT loop will exit. If the condition is unknown or false, the looping continues.