DB2 for i - DB Coding and Implementation Using DDS and CL Commands

Schedule

Start End Duration Location Details

Course Details

DB2 for i - DB Coding and Implementation Using DDS and CL Commands

Course code: OL62G

Duration: 3 Days


Prerequisite:

You must be able to:

•    Use Program Development Manager (PDM) and Source Entry Utility (SEU) to enter source code into a source file
•    Use PDM to create an IBM i object from a source file member
•    Explain the function of DDS in defining files on the i
•    Use Data File Utility (DFU) to maintain a physical file

Course Description:

Learn how to code, create and maintain DB2 UDB for i physical and logical files using native Data Description Specifications (DDS) and Control Language (CL) commands. Build a DB2 UDB for i relational database foundation, if you intend to write application programs for the IBM i system, however the course does not address SQL implementation of DB2 UDB for i.

Learn many techniques that, if implemented, enhance the performance of applications using the database.

Course Objectives:

After taking this course, you should be able to:

•    Code the DDS and create the physical and logical files necessary to implement a DB2 UDB for i relational database
•    Describe the advantages of a field reference file, code the necessary 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 the DB2 UDB for i referential integrity and triggers

Intended Audience:

•    This is a basic course for individuals who create and maintain a DB2 UDB for i database.

Course Outlines:

•    The relational database model
•    Creating physical files
•    Creating logical files
•    Database performance considerations for application design
•    Database maintenance
•    DB2 UDB for i referential integrity
•    DB2 UDB for i triggers
•    The relational database model
•    Creating physical files
•    Creating logical files
•    Database performance considerations for application design
•    Database maintenance
•    DB2 UDB for i referential integrity
•    DB2 UDB for i triggers