DB2 and PL/SQL features

Today, I answered an email in which I was asked whether DB2 supports PL/SQL and such features as exception handling, the Oracle data dictionary (system catalog), triggers, etc. My response was that many features, especially the most important ones, are supported and that it has become fairly easy - compared to some years back - to move from Oracle to DB2. Many companies are considering this, often as a way to start a dual vendor strategy and to save money.

How do you find out what is supported and how do you find more information? Here are some links:

• Introduction to compatibility features
• DB2 Information Center start page on PL/SQL support
• PL/SQL features in DB2
• Mapping of Oracle to DB2 error codes and exceptions
• Oracle data dictionary views in DB2
• Serge Rielau's blog with many SQL tips (not just for (former) Oracle users)
• A wiki on developerWorks with Oracle to DB2 migration tips & tricks and some news
• Henrik's resources page

Happy reading and have a nice weekend...