I have Db2 7.1 and the following script I try to execute
CREATE PROCEDURE aaww()
BEGIN
DECLARE i INTEGER DEFAULT 1;
ins_loop:
LOOP IF i>100 THEN
LEAVE ins_loop;
ELSEIF i<=100 THEN
ITERATE ins_loop;
END IF;
INSERT INTO TAB1 VALUES (i,'FIRST VALUES');
SET i = i + 1;
END LOOP;
END@
and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.