Re: creating a stored procedure in ISQL for Informix 5 online
Posted in 1997
David Williams — — source: Informix-list mailing list archive (1991-1998)
In article <01bd081a$d26c3280$6c54bace@glaurin2>, Greg Laurin
<glaurin@coldstorage.com> writes
>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 ?
>
You need to use dbaccess!!
>
>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
>
>
--
David Williams