Objectives
  At the end of this course, students will be able to:
  • Understand the basic concepts and facilities of DB2.
  • Use CLP commands and SQL to create relational objects for application development.
  • Use embedded STATIC SQL in 'C' or COBOL programs to access local or remote data, using single and multiple row (cursor) techniques.
  • Prepare and execute programs.
  • Understand the DB2 locking strategy for improving concurrency and maintaining data integrity.
  • Know how to design an Application program to manipulate data for a Distributed Unit of Work (DUW).
  • Know how to create Stored Procedures written in 'C'
Target Audience:
  Application developers and designers.
Prerequisites
 
  • Relevant Operating Systems experience (AIX, OS/2 or Windows).
  • 'C' or COBOL programming experience (basic skills).
  • Previous experience with relational database systems and SQL.
Duration
  Two days.

Outline for DB2 UDB Programming Fundamentals

Day 1

  • The DB2 Family
  • Getting started
  • Workshop - CLP
  • Creating Objects - Part 1
  • Workshop - Creating Objects
  • Static SQL in Programs
  • Error Handling
  • Program Preparation
  • Workshop - COBOL or ‘C’ programming

Day 2

  • Creating Objects - Part 2
  • DB2 Locking
  • DB2 Stored Procedures
  • Workshop - stored procedures
  • SQL Performance
  • Data Access and EXPLAIN
  • Workshop - explain