while statement

[Baron]

Can somebody tell me which mistake am I doing, why I get syntax error with this block?

create or replace procedure myproc()
begin
declare myvar int;
set myvar = 1;
while myvar <10 begin
set myvar= myvar+1;
end;
end;

[Baron]

as alternative this has worked:

create or replace procedure myproc()
begin
declare myvar int;
set myvar = 1;
myloop:
while myvar <10 loop
set myvar= myvar+1;
end loop myloop;
end;

[chris_keating]

The correct syntax for WHILE is

WHILE...LOOP END LOOP;

The loop name is optional. See LOOP in the documentation for a complete discussion.

[regdomaratzki · Accepted solution]

You are mixing your Watcom SQL and Transact-SQL into the same procedure. The brackets after the procedure name and the BEGIN..END after the procedure definition is Watcom-SQL, but you're trying to use the Transact-SQL version of the WHILE statement (i.e. no LOOP..END LOOP).

You alternative SQL for the procedure is all Watcom-SQL.