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), and 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.
At least six months of TSO/ISPF and COBOL programming experience is recommended. No previous database experience is needed.
5 Days/Lecture & Lab
This course is designed for experienced Data Processing personnel who need use SQL to design and develop programs to access DB2 data.
- Introduction to DB2
- Structured Query Language (SQL)
- DB2 Application Programming
- Additional Topics