CONTINUE [ statement-label ]

The CONTINUE statement is a control statement that allows you to restart a loop. Execution continues at the first statement in the loop. When CONTINUE appears within a set of Watcom-SQL statements, statement-label must be specified.

When CONTINUE appears within a set of statements using Transact-SQL, statement-label must not be used.

None.

None.

• LOOP statement
• WHILE statement [T-SQL]
• FOR statement
• BEGIN statement
• Using procedures, triggers, and batches

The following fragment shows how the CONTINUE statement is used to restart a loop. This example displays the odd numbers between 1 and 10.

BEGIN
   DECLARE i INT;
   SET i = 0;
   lbl:
   WHILE i < 10 LOOP
      SET i = i + 1;
      IF mod( i, 2 ) = 0 THEN 
         CONTINUE lbl
      END IF;
      MESSAGE 'The value ' || i || ' is odd.' TO CLIENT;
   END LOOP lbl;
END