Interskill Learning Mainframe Training

770-872-4278

The Online Mainframe Training Specialists
Search   Course Catalog   Live Chat!  
Return to Catalog Home     Return to Curriculum Listing

Introduction to DB2/400

Duration

3 hours

Overview

The Introduction to DB2/400 course introduces the two main DB2 file types, physical and logical files. It describes how to define and create them.

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 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

Looking for more information about Interskill Learning Products?
Contact our Learning Consultants or call us at 770-872-4278