LEAVE
The LEAVE statement is used in SQL Script to abort execution of the current block.
Syntax
LEAVE <label>
Remark
The LEAVE statement is equivalent to using break in Java. It aborts the current loop or compound statement block, without throwing an error.
Example
--Pads s with padChar so that s has at least width length.
PROCEDURE padr (IN s VARCHAR, IN width INTEGER, IN padChar VARCHAR, OUT result VARCHAR)
L-padr:
BEGIN
--Returns null if any parameter is null
IF s IS NULL OR width IS NULL OR padChar IS NULL THEN
LEAVE L-padr;
END IF;
...
END