Prev | SQL Engine Reference | Next |
LEAVE
Remarks
A LEAVE statement continues execution by leaving a block or loop statement. You can use LEAVE statements in the body of a stored procedure or a trigger.
Examples
The following example increments the variable vInteger by 1 until it reaches a value of 11, when the loop is ended with a LEAVE statement.
TestLoop: LOOPIF (:vInteger > 10) THENEND LOOP;LEAVE TestLoop;END IF; SET :vInteger = :vInteger + 1;See Also
Prev JOIN |
Contents Up Check for Revisions | Next LIKE |