Db2 for IBM i - Introduction for Programmers

Duration

3 hours

Overview

The Introduction to Db2 for IBM i course introduces the two main Db2 file types, physical and logical files. It describes how to define and create them.

Audience

This course is intended for new programmers, with some existing operational knowledge of databases and the workings of the IBM i system, who will be writing programs which access the IBM i database. At the completion of the course the student will have a basic understanding of the IBM i system's data file specifications (DDS) for both Physical and Logical files. This course is not intended to teach the basic operations of IBM i system and its usage. The course does not teach the actual creation of the database; neither are the steps such as editing and compiling a database file, and retrieving data using a programming language, covered in the course.

Prerequisites

Knowledge of data processing, programming concepts, and the IBM i operating system.

Objectives

After completing this course, the student will be able to:

• Describe the purpose of a Physical file
• Explain the usage of a Logical file
• Use IBM i database terminology when referencing database files
• Explain the use of trigger programs
• List the 3 basic ways programs access files
• Understand how program access files
• Know which files can have keys defined
• List the basic methods SQL can be used to access the database
• Indentify, read, and understand the basic elements of the DDS code for a Physical file
• Indentify, read, and understand the basic elements of the DDS code for a Logical file

Course Content

• Quick Course List

• 
  
  Courses Coming Soon