This chapter looked at the various features that can be used in a DB2 application program. We looked at how a unit of work is defined and how to use commits, rollbacks, and savepoints to protect the integrity of the data being manipulated by the program. Other features, such as temporary tables and identity columns, were considered in terms of how to make use of them in a program. Some coding techniques were also examinedsuch as FETCH FIRST n ROWSand various usages of this feature were also discussed. Many of these features can be used in an application program for enhanced functionality and optimal performance.