This tutorial contains an example of an Oracle e-commerce application that can be easily migrated to DB2 9.7 with the help of DB2 9.7's new PL/SQL support.

This simple e-commerce application registers customers, updates the product inventory, verifies product availability and simulates the creation of orders on a customers behalf. All database objects used in this application are defined using Oracle's DDL syntax and the entire business logic of this application is written in PL/SQL.

In this tutorial you will learn:


Prerequisites
In order to complete this tutorial you need to be connected to a DB2 9.7 database that is compatible with Oracle.

Follow these steps to create a compatible database:

  1. Stop the DB2 instance by running the "db2stop" command.
  2. Update the compatibility registry variable by running "db2set DB2_COMPATIBILITY_VECTOR=ORA".
  3. Start DB2 instance by running the "db2start" command.
  4. Create a new database by running the "db2 create database <new database name>" command.

Note: This tutorial requires the Technology Explorer for IBM DB2 version 3.3.238 or greater.