Re: creating stored procedures using ISQL
Posted in 1997
Stephanie und Andreas Ruf Rentsch — — source: Informix-list mailing list archive (1991-1998)
Greg Laurin wrote::
> This is something that sounds to simple but I can't create a stored
> procedure in ISQL
>
> I tried -
> CREATE PROCEDURE test()
> END PROCEDURE;>
> and it works, OK I tried -
>
> CREATE PROCEDURE test(ltqty INT)>
> let ltqty = ltqty / 2; -- I also tried it without the ;
>
> END PROCEDURE;
>
> and it gives me a syntax error, Why ?
>
> I have looked in all the manuals for I4GL 4.01 and ISQL 4.02 and there
> is
> nothing, absolutely nothing on stored procedures :(
>
> Thanks In advance for helping me with this simple and dump question
>
> Doug Gray
> penngray@netrover.com
You must use dbaccess to create stored procedures. It dosn't work with
ISQL