Moving MySQL trigger to DB2; issue with keyword NEW -

i have trigger working in mysql:

create trigger recharge_trigger after insert on recharges each row   update balances   set balance = balance + new.amount   uid = new.uid , stid = new.stid; 

it automatically updates balance column in balances table whenever insert row in recharges table.

however when tried run in db2, it's giving error:

server error: error batch element #1: "new.amount" not valid in context used.. sqlcode=-206, sqlstate=42703, driver=3.66.46

i think it's keyword new that's messing up. there way can write in db2?

i don't have access db2 database couldn't test looking @ documentation think need include referencing clause. try instead:

 create trigger recharge_trigger  after insert on recharges  referencing new n  each row mode db2sql  begin atomic   update balances set balance = balance + n.amount uid = n.uid , stid = n.stid;  end