Loading Course Schedule...
PT6068
Training 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.
Course 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