Migrating Oracle Instead of triggers to DB2

Currently DB2 is supporting instead of triggers but not in PL/SQL context. This may come in a near future version of DB2. who knows?!!

So, you'll need to migrate all of your triggers to DB2 SQL PL.

A possible workaround would be to move your trigger code into a stored procedure which takes two anchored parameters of the same view type (i.e. MyV%ROWTYPE). This should solve most of the effort.

Enjoy!