Problem in creating stored procedure in ISQL

Posted in 1998

Muppala, Sharath (Sharath)** CTR ** — Thu, 2 Jul 1998 12:41:07 -0400 — source: Informix-list mailing list archive (1991-1998)

Hi, I got to know that we can create stored procedures in ISQL 7.x apart from dbaccess. Iam 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. Thanks, Sharath Muppala.