Hi, I trying to create a trigger in DB2. But I am getting this error: An unexpected token "END-OF-STATEMENT" was found following "it_line DECIMAL(7,2)".
Code:
CREATE TRIGGER verify_purchase
NO CASCADE BEFORE INSERT ON Purchases
REFERENCING NEW AS n
FOR EACH ROW MODE DB2SQL
BEGIN
DECLARE credit_line DECIMAL(7,2);
SET credit_line = (SELECT Balance
FROM Balances B
WHERE B.Uid=n.Uid AND B.Stid=n.Stid);
IF (n.Amount) > credit_line THEN
SIGNAL SQLSTATE '80000' ('Order Exceeds credit line');
END IF;
END
@