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 features that an application developer can use. In this chapter, we will focus on all the basic techniques and aspects of application development that are very generic and can be used with any programming language. It will also help developers to...