Most likely you get a -104 syntax error?
The reason is that you have to change the statement terminator away from
the default ';'.
Depending on your version there should be box at the bottom of your pane
or in the preferences menu.
Popular characters are '$' or '@' since they don't occur in SQL naturally.

Cheers
Serge


"vijaykumar " <db2udbdba-ezmlmshield-x43985383.[Email address protected]
wrote on 04/25/2006 12:53:37 AM:

> 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
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>


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