DB2 An unexpected token "END-OF-STATEMENT" was found error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • wadephz
    New Member
    • Jul 2015
    • 1

    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
    			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
    @
Working...