You'll need to create two triggers.
One for AFTER INSERT
One for AFTER UPDATE

If what you need is two updates to fire after insert or update, you'll
still need two triggers and the two update actions will have to be part
of a compound sql stmt.
HTH, Pierre.

Prakash wrote:
> Hi:
>
> How do I create a trigger with 2 update operations in DB2. For ex, I
> want to create like the one below (oracle format)
> CREATE TRIGGER MY_TRIGGER
> AFTER INSERT OR UPDATE
> ON my_table_listing
> REFERENCING NEW AS NEW OLD AS OLD
> FOR EACH ROW
>
> How this can be done in DB2?
>
> Thanks
>
> V Prakash