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 ...

Get IBM DB2 9.7 Advanced Application Developer Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial