Live Chat Support

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

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

Overview

Duration : 3 Days

Learn how to code, create and maintain DB2/400 physical and logical files using native Data Description Specifications (DDS) and Control Language (CL) commands. Build a DB2/400 relational database foundation, if you intend to write application programs for the AS/400 system, however the course does not address SQL implementation of DB2/400.
Learn many techniques that, if implemented, enhance the performance of applications using the database.

Objectives

Course Objectives

  • 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
Course Content

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

Prerequisites

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 ID:
OL62G


Show Schedule for:

Please provide as much information as possible for us to help you with your enquiry.