Introduction to DB2/400

Duration

2 – 3 hours

Overview

Audience

Personnel requiring an introduction to AS/400 programming.

Prerequisites

Good knowledge of data processing, programming concepts, and the AS/400 Operating System. Introduction to Programming the iSeries – Courses 1 and 2.

Objectives

After completing this course, the student will be able to detail:
  • Physical and 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

Unit 1 INTRODUCTION TO DB2/400 PRETEST

Unit 2 INTRODUCTION TO DB2 UDB FOR ISERIES

  • Physical Files, Logical Files, SQL, and Trigger Programs

Unit 3 RECORD LEVEL ACCESS AND SQL

  • Record Level Access and Accessing DB2 UDB with SQL

Unit 4 INTRODUCTION TO PHYSICAL FILES

  • The DDS to Describe Physical Files

Unit 5 INTRODUCTION TO LOGICAL FILES

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

Unit 6 INTRODUCTION TO DB2/400 MASTERY TEST
 
© Copyright 2007. All rights reserved. Interskill Learning, Inc.