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;
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.