Chapter 6. DB2 9.7 Application Enablement

In this chapter, we will focus on the DB2 9.7 application enablement recipes, which help our other data server developer community to effortlessly code or enable the application on to DB2 data server.

We will cover the following recipes:

• First step towards enabling Oracle application to DB2 9.7

• Using ROWNUM and DUAL in DB2 9.7

• Using CUR_COMMIT concurrency-control isolation level

• Implementing hierarchical queries for recursion support

• Using PL/SQL ANONYMOUS block statements

• Handling RAISE_APPLICATION_ERROR in DB2 PL/SQL

• Migrating Oracle database objects on to DB2 9.7

• Porting multi-action triggers from Oracle to DB2 9.7

Introduction

DB2 9.7 introduces numerous features, which greatly reduce the application developer efforts, while enabling the application from a different data server to DB2. Earlier, DB2 9.5 introduced many features including implicit casting, synonym for DISCTINCT, EXCEPT, and SEQUENCES, global variables in packages, ARRAY collections, and...