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:

CLPPlus, an interactive command-line processor that is compatible with Oracle SQL*Plus
DB2 catalog information that presents information in a way that is compatible with how Oracle data dictionary views present information
System-defined modules, which are compatible with Oracle built-in packages

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.