Loading Course Schedule...
PT6068
Summary
This workshop is designed to provide instruction on COBOL programming using DB2 for OS/390. Hands-on practice with DB2 will be included, in order to reinforce the concepts and techniques studied in the course. Performance improving techniques will be discussed and the output from the DB2 optimizer will be analysed, using the EXPLAIN facility.
Prerequisites
Students should have COBOL programming experience. Some experience or classroom instruction in SQL is desired.
Duration
2 Days/Lecture & Lab
Audience
This course is designed for Programmers and programmer/analysts.
Topics
- SQL in PROGRAMS
- LAB preparation and LAB #0
- Error Handling
- DB2 Security
- LAB 1, workshop #2
- DB2 Objects
- DB2 Locking
- Query Analysis using EXPLAIN