Thanks Doug. That worked!


On Mon, May 11, 2009 at 04:05, Doug Lawry <> wrote:
Hi Krishna.

You have to change the Statement Separator to something else temporarily -
by convention "GO" as in SQL Server - in Session / Session Properties / SQL.
You will find that your code then works fine. If you were going to have
other statements in your script, you would need "GO" between them.

Doug Lawry

From: Krishna
Sent: Sunday, May 10, 2009 12:26 PM
Subject: [Squirrel-sql-users] Editing stored procedures in Informix

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

The following (which is a valid Informix stored procedure) fails with an

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.