iSeries DB2 Universal Database Coding (DDS)& Implementation (OL62)

Format

Classroom

Duration

4.0 Day(s)

Description

This classroom course of two and a half days teaches basic relational database theory, coding, creation, and maintenance of DB2/400 physical and logical files. It teaches many techniques that, if implemented, will enhance the performance of applications using the database. This course does not include any discussion of creating or using a database via SQL.

Audience

This course is designed for persons who will be responsible for creating and maintaining a DB2/400 database. This course will also provide the necessary DB2/400 Relational Database foundation for those persons intending to write application programs for the DB2/400 System.

Prerequisites

Before taking this course, a student should be able to:
- Use PDM/SEU to enter source code into a source file.
- Use PDM to create an AS/400 object from a source file member.
- Explain the function of Data Description Specifications (DDS) in defining files on the AS/400.
- Use DFU to maintain a physical file.
These prerequisites can be met by successful completion of:
- AS/400 Concepts and Programming Facilities (S6049)

Objectives

After completing this course, a student should be able to:
- Given a relational database design, code the Data Description Specifications (DDS) and create the physical
and logical files necessary to implement a DB2/400 Relational Database.
- Describe the advantages of a Field Reference File, code the necessary Data Description Specifications (DDS) and create a Field Reference File.
- Explain how the choices made while coding the DDS and creating the file affect the performance of the system and the programs using the files.
- Describe the considerations for using DB2/400 referential integrity and triggers.