Help!!! syntax error

Hi everybody, Im trying to create a simple store procedure but I get
an error when I define the variables.

Code:

CREATE PROCEDURE scope()
DEFINE x,y,z INT;
LET x = 5;
LET y = 10;
LET z = x + y; --z is 15
BEGIN
DEFINE x, q INT;
DEFINE z CHAR(5);
LET x = 100;
LET q = x + y; -- q = 110
LET z = 'silly'; -- z receives a character value
END
LET y = x; -- y is now 5
LET x = z; -- z is now 15, not 'silly'
END PROCEDURE;



Error:

Error: A syntax error has occurred.
SQLState: 42000
ErrorCode: -201
Position: 41
Error occured in:
CREATE PROCEDURE scope()
DEFINE x,y,z INT

On 3 dic, 11:24, Art Kagel wrote:
> You need a semi-colon after the closing parenthesis of the procedure's
> argument list.  So:
>
> CREATE PROCEDURE scope();
>        DEFINE x,y,z INT;
>        LET x = 5;
>        LET y = 10;
>        LET z = x + y; --z is 15
>        BEGIN
>                DEFINE x, q INT;
>                DEFINE z CHAR(5);
>                LET x = 100;
>                LET q = x + y;     -- q = 110
>                LET z = 'silly'; -- z receives a character value
>        END
>        LET y = x; -- y is now 5
>        LET x = z; -- z is now 15, not 'silly'
> END PROCEDURE;
>
> Art
>
> Art S. Kagel
> Oninit (www.oninit.com)
> IIUG Board of Directors (a...@iiug.org)
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions and
> do not reflect on my employer, Oninit, the IIUG, nor any other organization
> with which I am associated either explicitly or implicitly.  Neither do
> those opinions reflect those of other individuals affiliated with any entity
> with which I am affiliated nor those of the entities themselves.
>
>
>
> On Thu, Dec 3, 2009 at 12:16 PM, Oskr wrote:
> > Hi everybody, Im trying to create  a simple store procedure but I get
> > an error when I define the variables.
>
> > Code:
>
> > CREATE PROCEDURE scope()
> >        DEFINE x,y,z INT;
> >        LET x = 5;
> >        LET y = 10;
> >        LET z = x + y; --z is 15
> >        BEGIN
> >                DEFINE x, q INT;
> >                DEFINE z CHAR(5);
> >                LET x = 100;
> >                LET q = x + y;     -- q = 110
> >                LET z = 'silly'; -- z receives a character value
> >        END
> >        LET y = x; -- y is now 5
> >        LET x = z; -- z is now 15, not 'silly'
> > END PROCEDURE;
>
> > Error:
>
> > Error: A syntax error has occurred.
> > SQLState:  42000
> > ErrorCode: -201
> > Position: 41
> > Error occured in:
> > CREATE PROCEDURE scope()
> >        DEFINE x,y,z INT
> > _______________________________________________
> > Informix-list mailing list
> > Informix-l... DeleteThis @iiug.org
> >http://www.iiug.org/mailman/listinfo/informix-list- Ocultar texto de la cita -
>
> - Mostrar texto de la cita -

Now I get the next error:

Error: A syntax error has occurred.
SQLState: 42000
ErrorCode: -201
Position: 23
Error occured in:
CREATE PROCEDURE scope()