DB2 Application Programming

PT6070
Training Summary
This workshop is designed to provide knowledge of using SQL in DB2 for OS/390 or z/OS. This knowledge can be applied to implementing SQL into programs (COBOL programs will be used). 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.
Duration
5 Days/Lecture & Lab
Audience
This class is designed for Programmers, Analysts, Project leaders, managers and end users, who need to access DB2 data on OS/390 or z/OS.
Course Topics
  • Basic Theory
  • SQL Table Joins
  • Preview (optional)
  • Program Preparation
  • COMMITS and BATCH PROGRAMS

Related Scheduled Courses