Does anyone know if it's possible to Include files (code) in a SP written in Developer Center.

What i want is something like this

<This is the working way>
CREATE PROCEDURE AAAA (IN EMPNUMBR CHAR(6), OUT SQLCPARM INTEGER)
LANGUAGE SQL

BEGIN:
DECLARE SQLCODE INTEGER;
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
SET SQLCPARM = SQLCODE;
>

But i want to have the same errorfile to all my sp's.
<Can i do this>
CREATE PROCEDURE AAAA (IN EMPNUMBR CHAR(6), OUT SQLCPARM INTEGER)
LANGUAGE SQL

BEGIN:
#INCLUDE errorDeclares
SET SQLCPARM = SQLCODE;

>

Regards

Bjórn Jonsson

No, Only SQL is allowed in a SP. You will need to explicitly declare the stuff each time.

Andy