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!

IBM to unveil NoSQL technology inside DB2

Curt Cotner, IBM's vice president and chief technology officer for database servers, Announces that IBM plans to inject NoSQL technology in DB2 database system early next year. IoD Vegas 2011.

For more information plz check: http://searchdatamanagement.techtarget.com/news/2240102614/IBM-to-unveil-NoSQL-technology-inside-DB2