Move to next iteration in WHILE loop SQL-PL DB2

Question

Is there a way to tell a program to move to the next iteration of a while loop in SQL-PL for DB2? I know that there is a CONTINUE statement, but it isn't working for me.

I basically want:

WHILE .... DO
    IF condition_met THEN
        -- Move to next iteration of the while loop
    END IF;
END WHILE;

I think you mean SQL-PL? "PL/SQL" is the Oracle language – Tony Andrews Mar 10 '16 at 16:28 — Tony Andrews, Mar 10 '16 at 16:28
Version and platform of DB2? – Charles Mar 10 '16 at 16:50 — Charles, Mar 10 '16 at 16:50
Yep you are correct Tony. And I am running 9.7 Charles. – colmulhall Mar 11 '16 at 09:06 — colmulhall, Mar 11 '16 at 09:06

score 1 · Accepted Answer · answered Mar 10 '16 at 16:34

1

Look at the ITERATE command in the Knowledge Center. The ITERATE statement causes the flow of control to return to the beginning of a labelled loop.

answered Mar 10 '16 at 16:34

proksch_ibm

278
1
9

Thanks for your help! The ITERATE command worked for me. I also had to add a LABEL to my while loop so that I could use the ITERATE command. – colmulhall Mar 11 '16 at 09:08

Move to next iteration in WHILE loop SQL-PL DB2

1 Answers1