Chapter12.Application Program Features

Chapter 12. Application Program Features

• Commit, rollback, and savepoint operations

• Global transactions

• Fetching for limited rows

• Identity columns

• Sequence objects

All SQL programs execute as part of an application process, which involves the execution of one or more programs and is the unit to which DB2 allocates resources and locks. Different application processes might involve the execution of different programs or different executions of the same program. The means of initiating and terminating an application process are dependent on the environment.