while statement

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;

syntax-error

asked 22 Jun, 08:08

Baron
2.0k●125●138●165
accept rate: 48%

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;

(22 Jun, 08:13) Baron

The correct syntax for WHILE is

WHILE...LOOP END LOOP;

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

(22 Jun, 08:20) Chris Keating

flat view

One Answer:

active answers oldest answers newest answers popular answers

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.

permanent link

answered 22 Jun, 08:40

Reg Domaratzki
7.6k●3●43●115
accept rate: 37%

edited 22 Jun, 08:54

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

syntax-error ×19

question asked: 22 Jun, 08:08

question was seen: 134 times

last updated: 22 Jun, 08:54

SAP SQL Anywhere

while statement

Follow this question

Related questions