This version supports the following syntax:
GOTO statement and Label syntax
Example:
define x integer;Let x = 0;BEGIN <<increment_x>> BEGIN LET x = x + 1; END;
IF x < 10 THEN GOTO increment_x; END IF;END;
- A GOTO statement cannot be used in an EXCEPTION block.
- Labels cannot be defined within an EXCEPTION BLOCK.
- A label must be unique within a stored procedure.
Loop .. End Loop syntax
Example:
LOOP IF credit_rating IS NULL THEN CONTINUE; (or CONTNUE LOOP) END IF IF credit_rating < 3 THEN EXIT; (or EXIT LOOP)-- exit loop immediately END IFEND LOOP;
WHILE
<
Example:
WHILE (i < 10) LOOP LET i = i + 1 ; IF i < 2 THEN CONTINUE; END IF IF i > 5 THEN EXIT; END IFEND LOOP;
<<mywhile>>WHILE (i < 10) LOOP LET i = i + 1 ; IF i < 2 THEN CONTINUE; END IF IF i > 5 THEN EXIT; END IFEND LOOP mywhile;
FOR
<
Example:
FOR i IN (1 TO 5) LOOP LET i = i +1 ; IF i < 2 THEN CONTINUE; IF i > 5 THEN EXIT; END IF; END LOOP;
Expression based exit statement.
- EXIT WHEN <expr>;
- EXIT loop_label WHEN <expr>; -- Label Based Exit.
<<outer>> LOOP LET x = x+1; <<inner>> for i in ( 1 to 10) LOOP LET x = x+1; EXIT inner WHEN x = 2; EXIT outer WHEN x > 3; END LOOP inner; LET x = x+1; END LOOP outer;
Suma Vinod[Read More]