Duration
3 days
Audience
Individuals who create and maintain a DB2/400 database.
Prerequisites
You should 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 Objectives
- Code the 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 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
Course Content
- The relational database model
- Creating physical files
- Creating logical files
- Database performance considerations for application design
- Database maintenance
- DB2/400 referential integrity
- DB2/400 triggers
Programme scope, delivery arrangements and suitability are confirmed during enquiry.