KT-OV620 DB2 UDB for i Database Coding and Implementation Using DDS and CL Commands Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University


Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training



 Course Search
Course #

 Training Delivery
Training Delivery
Custom Curriculum
Course List
 Main Menu
View Courses
Site Index

DB2 UDB for i Database Coding and Implementation Using DDS and CL Commands



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.


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


  • 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

Click here to view the Course Outline

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

View Printer Friendly Page


Course Schedule
  Start Date  City  Price  

To Inquire About Future Classes

Request a class date

if one is not scheduled.