[Squirrel-sql-users] CREATE OR REPLACE PROCEDURE for Netezza

[Donald I. <don...@gm...>]

Does Squirrel support the creation of Netezza Procedures?

Code:
CREATE OR REPLACE PROCEDURE dci_test_proc() RETURNS INT4 LANGUAGE NZPLSQL AS
BEGIN_PROC
DECLARE
string varchar(100);
BEGIN
string := 'This string is quoted';
END;
END_PROC;


I am getting the following error:


SQLState:  HY000
ErrorCode: 1100
Error occured in:
CREATE OR REPLACE PROCEDURE dci_test_proc() RETURNS INT4 LANGUAGE NZPLSQL AS
BEGIN_PROC
DECLARE
string varchar(100)


Thank you.