Re: Problem in creating stored procedure in ISQL

On Thu, 2 Jul 1998, Muppala, Sharath (Sharath)** CTR ** wrote: > I got to know that we can create stored procedures in ISQL 7.x apart from > dbaccess. No -- ISQL (still) does not understand stored procedures with semi-colons in the middle. You've demonstrated that. It is a FAQ-type question. > I am having ISQL 7.2. I tried a small Stored procedure program on > dbaccess 7.4 and ISQL 7.2. It is successfully created on dbaccess but not on > ISQL.Error is "201: A syntax error has occurred". Here is the code. > > create procedure add(a int,b int) returning int;> define c int; > let c= a + b; > return c; > end procedure; > > Is the problem with the code or ISQL. > I would appreciate any explanation. ISQL Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix -- see http://www.perl.com/CPAN