Objectives:
  After completing this course the student should be able to:
  • Understand the concepts of a relational database system.
  • Use SPUFI (on TSO/ISPF) to write SQL queries.
  • Embed SQL commands into a batch COBOL program to read and update data from tables.
  • Code a SQL in a program to access multiple rows of data.
  • Prepare and execute programs.
  • know the locking strategies available with DB2.
  • understand the basic features and options available when using DB2 packages and plans.
  • Be familiar with several DB2 objects.
  • Identify SQL performance improving techniques and use EXPLAIN to analyse SQL statements.
  • Design DB2 indexes for performance.
  • Identify design issues in batch programs that require SQL COMMIT commands. Identify techniques for recovery and restartability in programs.
Target Audience:
  Programmers, Analysts, Project leaders, managers and end users, who need to access DB2 data on OS/390 or z/OS.
Prerequisite:
  COBOL programming experience.
Format:
  Lecture with hands-on workshops.
Duration:
  Five days.

Outline for DB2 for z/OS Application Programming

Day 1

  • Basic Theory
  • SQL Introduction
  • SPUFI
  • SQL Lab 1
  • SQL Basics
  • SQL Lab 2
  • SQL Basics (continued)
  • SQL Lab 3

Day 2

  • SQL Table Joins
  • SQL Lab 4
  • SQL Subselect
  • SQL Lab 5
  • DML and Objects
  • SQL Lab 6

Day 3

  • Preview (optional)
  • SQL in PROGRAMS
  • LAB preparation and workshop #1
  • Error Handling
  • workshop #2

Day 4

  • Program Preparation
  • DB2 Security
  • workshop #3
  • DB2 Objects
  • DB2 Locking
  • SQL - OUTER JOINS/CASE Expressions
  • workshop #4
  • SQL for PERFORMANCE
  • The DB2 CATALOG
  • workshop #5

Day 5

  • COMMITS and BATCH PROGRAMS
  • ONLINE PROGRAMMING
  • Using EXPLAIN
  • workshop #6
  • REVIEW of the latest enhancements in DB2