Aqua Data Studio 15.0.0-dev-96
Build #: 35893
Built on: 2014-Feb-06 02:45:16 PM
Database: Informix 12.1
Operating environment: Windows 7 x64
Connect to Informix
Create a table named 'customer'
Create table script:
CREATE TABLE informix.customer (
customer_num SERIAL NOT NULL,
fname CHAR(15),
lname CHAR(15),
company CHAR(20),
address1 CHAR(20),
address2 CHAR(20),
city CHAR(15),
state CHAR(2),
zipcode CHAR(5),
phone CHAR(18),
PRIMARY KEY(customer_num)
ENABLED
)
LOCK MODE PAGE
GO
Create a procedure named 'read_address'
Create procedure script:
CREATE PROCEDURE informix.read_address(lastname CHAR(15))
RETURNING CHAR(15),CHAR(15);
DEFINE p_lname,p_fname CHAR(15);
SELECT fname,lname INTO p_fname,p_lname FROM customer WHERE lname = lastname;
RETURN p_fname, p_lname;
END PROCEDURE
GO
Right click on created procedure
Select drop procedure
It shows an error message:
'A syntax error has occurred'
Same error occurs when we try to run drop procedure script through query analyzer window
This is fixed with Ivans change in 15.0.7-10