Question Re: while statement in Technology Q&A

while statement

Baron — Thu, 22 Jun 2023 08:08:32 GMT

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;

Re: while statement

Baron — Thu, 22 Jun 2023 08:13:46 GMT

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;

Re: while statement

chris_keating — Thu, 22 Jun 2023 08:20:26 GMT

The correct syntax for WHILE is

WHILE...LOOP END LOOP;

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

Re: while statement

regdomaratzki — Thu, 22 Jun 2023 08:40:46 GMT

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.