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.

DB2 for z. OS Version 8 DBA Certification Guide
DB2 for z/OS Version 8 DBA Certification Guide
ISBN: 0131491202
EAN: 2147483647
Year: 2003
Pages: 175
Authors: Susan Lawson © 2008-2017.
If you may any questions please contact us: