DB2® Universal Database for OS/390 V7.1 Application Certification Guide

SUSAN LAWSON is an internationally recognized consultant and lecturer who currently works with several clients to help develop, implement, and tune some of the world's largest and most complex DB2 databases. She is an IBM Gold Consultant for DB2 and S/390 and an IBM Certified DBA and Application Developer for DB2 UDB Version 7 for OS/390.

Preface.


Part 1: Introduction to DB2 UDB for OS/390 and z/OS.


Part 2: Structured Query Language.


Part 3: Developing Applications.


Part 4: Programming and Language Environments.


Part 5: Advanced Programming Functions.
I. INTRODUCTION TO DB2 UDB FOR OS/390 AND Z/OS.

1. Product Overview.


DB2 and e-business. DB2 Universal Database. DB2 Middleware and Connectivity. DB2 Application Development. DB2 Administration. Data Management Tools. Summary. Additional Product Resources.

2. Database Objects.


Understanding Data Structures. Managing Database Objects. Database Design and Implementation. Access to DB2 Objects. Summary. Additional Resources.

II. STRUCTURED QUERY LANGUAGE.

3. Basic SQL Coding.


Data Retrieval. Data Modification. Inserting Data Records. Updating Data Records. Removing Data. View Classification. Summary. Additional Resources.

4. Advanced SQL Coding.


Subqueries. Unions. Nested Table Expressions. Joins. CASE Expressions. Row Expressions. OLAP Features. Summary. Additional Resources.

III. DEVELOPING APPLICATIONS.

5. Using SQL in an Application Program.


DB2 Application Development Environment. Delimiting SQL in a Program. Declaring Table and View Definitions. Host Variables and Host Structures. SQL Execution Validation. Using Cursors. Using Dynamic SQL. Summary. Additional Resources.

6. Binding an Application Program.


Precompile and Bind. Plan or Package Ownership. Summary. Additional Resources.

7. Application Program Features.


Application Program Features. Commit, Rollback, and Savepoint. Global Transactions. Global Temporary Tables. Fetch for Limited Rows. Identity Columns. Summary. Additional Resources.

8. Stored Procedures.


Stored Procedures. Benefits. Writing Stored Procedures. Defining Stored Procedures. Execution Environments. Stored Procedure Address Space (SPAS). Workload Manager. SQL Procedure Language. Developing SQL Stored Procedures. Stored Procedure Builder. Summary. Additional Resources.

9. Testing and Debugging Applications.


Establishing a Test Environment. Debugging Application Programs. Locating the Problem. Testing and Debugging Stored Procedures. Summary. Additional Resources.

10. Accessing Distributed Data.


Distributed Data. Coding Methods for Distributed Data. Programming Considerations. Remote Query Performance. Summary. Additional Distributed Resources.

IV. PROGRAMMING AND LANGUAGE ENVIRONMENTS.

11. ODBC/CLI Programming.


Embedded Dynamic Versus Call-Level Interface. The DB2 ODBC Environment. Handles. Database Connections. Transaction Control. Executing SQL Statements. Retrieving Results. ODBC Stored Procedures. Error Handling and Problem Determination. Sample program. Summary. Additional Resources.

12. DB2 Traditional Programming.


COBOL. C and C++. REXX. Summary. Additional Resources.

13. Java Programming.


DB2 and Java. JDBC. SQLJ. Design Guidelines for Applications. Java Stored Procedures and UDFs. Summary. Additional Resources.

14. Attachment Programming.


Attachments. TSO. CICS. IMS. Call Attachment Facility. RRSAF. Summary. Additional Resources.

V. ADVANCED PROGRAMMING FUNCTIONS.

15. Object-Relational Programming.


Triggers. Object-Relational Extensions. Extenders. LOB and Extender Usage. Enabling Extenders. Summary. Additional Resources.

16. Locking and Concurrency.


Locking Data. Avoiding Locks. System Parameters. Claims and Drains. Locking Issues and Problems. Summary. Additional Resources.

17. Application Performance and Optimization.


Elements of Performance. Tuning Guidelines. Access Paths and Optimization. Designing Indexes for Performance. Query Parallelism. Database Monitoring. Tracing Problems in DB2. Using DISPLAY Commands. Summary.

Appendix A. IBM Certified Solutions Expert-DB2 UDB Family Application Development.


Certification Test Objectives. Sample Test.

Appendix B. Resources.


DB2 Universal Database Server for OS/390 v7 Product Libraries.

Appendix C. DB2CERT Database DDL.
Index.