First, the concepts of DB2 are presented and discussed.
The Structured Query Language (SQL) is presented as the means to access DB2 data (and to create and secure DB2 components). Several guided, hands-on, practice sessions give each attendee an opportunity to use SQL to access data. QMF and/or SPUFI are used to execute SQL statements. Referential Integrity concepts and implementation are covered.
DB2 (SQL) programming / embedding SQL in a COBOL application program is presented and discussed in detail. A "shell" program is modified to SELECT a single row, FETCH multiple rows, INSERT, UPDATE, and DELETE row(s), use Referential Integrity, and use column functions and grouping.
DB2 performance guidelines are discussed. The SQL statement EXPLAIN PLAN is used to help to evaluate the efficiency of SQL statements.
The following “Release Dependent” features are also covered –
> Version 7 - UNION Everywhere, Scrollable cursors, Limited Fetch
> Version 8 – Table-Controlled Partitioning, Common Table Expression, Dynamic Scrollable Cursors, multi-row FETCH and INSERT, GET DIAGNOSTICS, Recursive SQL, Sequence Objects, Scalar Full Select, Select Statement In An Insert statement, Delimited LOAD / UNLOAD, MQT’s
Also, a demonstration is provided of DB2 for WINDOWS to show "future" features for DB2 for z/OS. These include GROUPING SETS, ROLLUP, and Visual Explain.