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:
Note: This tutorial requires the Technology Explorer for IBM DB2 version 3.3.238 or greater.