Using version: 2.5
 
Am unable to create stored procedures in Informix using Squirrel SQL. Am able to create procedures in SQL Server, though. What is it that I am doing wrong? Is creation of stored procedure on Informix not supported by Squirrel?
 
The following (which is a valid Informix stored procedure) fails with an exception:
 
create procedure abcd()
define i int;
end procedure;
 
Exception:
Error: java.sql.SQLException: A syntax error has occurred., SQL State: 42000, Error Code: -201
Error occured in:
create procedure abcd()
    define i int
 
Thanks for the pointers.
 
Krishna