Chapter 5: Conversion Reference

---

Overview

In the previous chapter, we showed you how the IBM Migration Toolkit (MTK) for Oracle is able to automate conversion of most Oracle database objects and proprietary SQL to DB2 UDB. If your database uses many Oracle proprietary features, there may be some SQL that the MTK cannot automate. In this chapter, we show you some examples of how to perform conversions manually, with a focus on converting Oracle objects and features that are not automated by MTK.

We start by exploring some tools and methods for building DB2 triggers, functions, and procedures. Through examples, we look at techniques for converting frequently used PL/SQL features to DB2 SQL PL code. We also discuss how to build external procedures and functions using C/C++ and Java.

Although we start this chapter by demonstrating basic syntax for creating procedures, triggers, and functions in both Oracle and DB2 UDB, the intent is to demonstrate how to convert these objects manually when needed - not to be a complete reference for developing DB2 SQL PL (other books are available for that). The reader is expected to have some prior application development experience in both Oracle PL/SQL and DB2 SQL PL in order to fully understand the examples used in this chapter.

---