Mechanisms of support for Oracle applications in version 9.7.5 IBM DB2 Express-C environment intended for community

Paweł Drzymała, Henryk Welfle


The article presents the mechanisms of support to run Oracle applications in DB2 9.7.5 Express-C environment. It presents the possibility of compilation and execution applications in the DBMS DB2 9.7 Express-C using SQL, PL/SQL and Oracle objects. This version implements support of Oracle 10g and 11g, which was previously available only in Enterprise Edition. In relation to older commercial versions it introduced new levels of Oracle compatibility. The article presents also how to configure DB2 to work with the PL/SQL language.


IBM DB2 9.7.5 Express-C; Oracle; DB2_COMPATIBILITY_VECTOR; compatibility Oracle in DB2

Full Text:

PDF (Polski)


Drzymała P., Welfle H.: Przetwarzanie zapytań rozproszonych w środowisku InfoSphere Federation Server stowarzyszonym z bazami danych Oracle. Studia Informatica, Vol. 32, No. 2B(97), Wydawnictwo Politechniki Śląskiej, Gliwice 2011, s. 359÷372.

Smarter Planet IBM,

Chong R.F., Liu C., Qi C.F., Snow D.R.: Understanding DB2: Learning Visually with Examples.

IBM DB2 dla systemów Linux, UNIX i Windows - Centrum informacyjne,

Chen W.-J., Chen K., Dantressangle P., Greenstein M., Lightstone S., Petrenko M., Reutlinger R., Rielau S., Schormann S., Schwenger M.N.: Oracle to DB2 Conversion Guide: Compatibility Made Easy. RedBooks, November 2009.