Re: creating a stored procedure in ISQL for Informix 5 onlin

Greg, You can't create SPL's in ISQL you get syntax errors and other stuff you have to use DBACCESS. Regards David Ashby ______________________________ Reply Separator _________________________________ Subject: creating a stored procedure in ISQL for Informix 5 online Author: "Greg Laurin" <glaurin@coldstorage.com> at WCA-INET Date: 13/12/97 10:55 PM 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