Introduction to DB2/400

Duration

2 to 3 hours

Overview

Audience

Personnel requiring an introduction to iSeries programming.

Prerequisites

Completion of the courses Introduction to Programming the iSeries Part 1 and Part 2, and knowledge of data processing, programming concepts, and the iSeries operating system.

Objectives

After completing this course, the student will be able to identify:
• Physical files, logical files, and trigger programs
• Record level access and SQL statements
• The DDS used to create physical files
• The DDS used to create logical files

Course Content

Introduction to DB2/400 Pretest

Introduction to DB2 UDB for iSeries

Physical Files, Logical Files, SQL, and Trigger Programs

Record Level Access and SQL

Record Level Access and Accessing DB2 UDB with SQL

Introduction to Physical Files

The DDS to Describe Physical Files

Introduction to Logical Files

The DDS to Describe Logical Files
Logical File Concepts
The DDS to Describe Logical Files
Use of Logical Files

Introduction to DB2/400 Mastery Test