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