DB2 9.7 & PL-SQL Compatibility

Hi Everyone...

This is the first post in a too long time, but you know how the work consumes the time, anyway I wishing you a Happy 2010.

The new DB2 9.7 engine, supports PL-SQL as a new feature and aggressive strategy of IBM to down the selling of Oracle products. The support is simply simple to manage and use, here a little table of the features that I have tested of the DB2:

Oracle Database Feature	DB2 9.7 Support
Concurrency control	Native support
Data types	Native support
SQL dialect	Native support
PL/SQL	Native support
PL/SQL packages	Native support
Built-in packages	Native support
JDBC client with extensions	Native support
SQL*Plus scripts	Native support

This is a little preview, in other post I’ll show some examples of many different difficulties of common problems and features that DBA’s uses in a real environment.

Hope it helps…

Paul