DB2 An unexpected token "END-OF-STATEMENT" was found error
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