Store Procedure Question
Could someone please help me with this procedure, I am getting an error
201
as shown below when compiling.
Thank you very much
Adam Sorati
adams@sgen.com.au
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-- STORED PROCEDURE TO INSERT/UPDATE week_sales TABLE
DROP PROCEDURE create_wksls;
CREATE PROCEDURE create_wksls(sku INTEGER, store SMALLINT, date_sold
DATE,
trans_type CHAR(1), sold_qty INTEGER,
sold_sell DEC(5,2))
DEFINE global gsi_year, gsi_week SMALLINT DEFAULT 0;
*** Error 201 ***
DEFINE global gsell DEC(5,2) DEFAULT 0;
etc.