Implementing Practical DB2 Applications

1. Introduction.- 1.1 DATABASE2 (DB2) environment.- 1.2 DB2 data objects.- 1.3 Access to DB2 tables.- 1.4 Use of SQL.- 1.5 Use of SQL from applications.- 2. Application Design.- 2.1 Application design.- 2.2 Application considerations.- 2.3 Which product to use.- 3. QMF Facilities.- 3.1 Introduction.- 3.2 QMF objects.- 3.3 QMF invocation.- 3.4 QMF command facilities.- 3.5 Invocation of QMF.- 3.6 QMF callable interface.- 3.7 QMF command interface.- 4. QMF Commands.- 4.1 Introduction.- 4.2 Commands.- 4.3 Example.- 4.4 External QMF data.- 4.5 QMF external data format.- 4.6 IXF data.- 4.7 QMF external data.- 4.8 QMF data format.- 4.9 QMF report data.- 5. Program Environment.- 5.1 Introduction.- 5.2 JCL procedures.- 5.3 Example.- 5.4 DB2I (DB2 Interactive).- 6. DB2 program Invocation.- 6.1 Introduction.- 6.2 Commands pertaining to DB2.- 6.3 DB2 subcommands.- 6.4 DB2I (DATABASE2 Interactive).- 6.5 Invoke program independent of DB2 (CAF interface).- 7. Issuing SQL statements from within a program.- 7.1 Introduction.- 7.2 SQL status.- 7.3 Program host variables.- 7.4 Indicator variables.- 7.5 Use of SQL from programs.- 8. Embedded SQL Statements.- 8.1 Introduction.- 8.2 Statements.- 9. Transaction Processing.- 9.1 Introduction.- 9.2 SQL transaction concepts.- 9.3 Consistency.- 9.4 Concurrency.- 10. Testing.- 10.1 Introduction.- 10.2 DB2 testing tools.- 10.3 Testing of programs using DB2 (SQL) facilities.- 10.4 Commit/Rollback in the testing environment.- 10.5 Summary.- 11. Worked Example.- 11.1 Introduction.- 11.2 Problem specification.- 11.3 QMF solution.- 11.4 Program solution.- 11.5 Summary.- Appendix A. Syntax Notation.- Appendix B. SQL Control Areas.- Appendix C. Glossary.