Chapter 2. DB2 Application Techniques

In this chapter, we will focus on the following recipes describing the common DB2 techniques for application development:

  • Granting and revoking instance-level authorities
  • Granting and revoking database-level authorities
  • Granting and revoking object privileges
  • Implementing static SQL in DB2
  • Implementing dynamic SQL in DB2
  • Creating Declared Global Temporary Tables (DGTTs)
  • Using XML in a declared temporary table
  • Improving performance by creating indexes on a DGTT
  • Creating Created Global Temporary Tables (CGTT)
  • Using generated columns in tables
  • Creating a savepoint
  • Using savepoints in JDBC
  • Using savepoints in SQLJ
  • Creating a sequence object
  • Modifying a sequence object
  • Referencing a sequence object

Introduction

DB2 provides many ...

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.