DB2 Version 9.7 for Linux, UNIX, and Windows

SQL compatibility enhancements

If you work with Oracle databases, you will find that Version 9.7 contains many new enhancements that make the DB2 products more familiar to you. These enhancements also make it particularly easy to enable Oracle applications to run quickly in DB2 environments.

For example, Version 9.7 introduces the following application and administration interfaces that will be familiar to Oracle users:
In addition, if you also work with Oracle software, you will be familiar with several new SQL constructions and semantics when writing and running Version 9.7 applications:

You control which of these compatibility features are enabled using specific settings of the DB2_COMPATIBILITY_VECTOR registry variable. For more information, see Oracle-compatible mode can be enabled.