Re: creating stored procedures using ISQL

Hey Guys, If you are interested in doing alot with stored procedures I really recommend using Informix Relational Object Manager. It is used in an NT/Win 95 environment and will use ODBC to connect to the database. It is a graphical Database Manager Environment, you can work in an SQL window which will edit check your SQL for Stored Procedure syntax. It was available to download for free at www.informix.com. I think it is really nice and although it is brand new (hopefully they will add capability) it works well for me!! I am using S-DESIGNOR and can quickly create schemas, indexes, stored procedures, triggers and pound'em into the database. Hey, this company makes good stuff!!! :) David Meyer Guerilla Software ps... a good book for store procedures is INFORMIX STORED PROCEDURE PROGRAMMING by Michael Gonzales - Informix Press. Small but good. In article <34A8161E.38D9AF00@swissonline.ch>, Stephanie und Andreas Ruf Rentsch <ruf-rentsch@swissonline.ch> wrote: > 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