where i have to run the create trigger script. when i try to run the script in command line editor it shows error.
the trigger script is

CREATE TRIGGER DB2ADMIN.INS_BATCH_SHEET AFTER INSERT ON DB2ADMIN.TB_BATCH_SHEET_DTL REFERENCING NEW AS newrow FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
update vj set prod_ord_qty = prod_ord_qty + newrow.quantity_produced;
END


please give me solution

by

vijaykumar.g

DB2 & UDB email list listserv db2-l LazyDBA home page