Terminating module execution

Available in

Syntax

The EXIT statement causes execution of the procedure or trigger to jump to the final END statement from any point in the code, thus terminating the program.

Using the EXIT statement in a selectable procedure:

CREATE PROCEDURE GEN_100
RETURNS (
)
BEGIN
  I = 1;
  WHILE (1=1) DO
  BEGIN
    IF (I=100) THEN
      EXIT;
    I = I + 1;
  END

See also