OL62: DB2 for i: DB Coding and Implementation Using DDS and CL Commands
DURATION: 3 days
SCHEDULED DATES: TBD – Contact Us for more Information
PURPOSE
This classroom course of three days teaches basic relational database theory, coding, creation, and maintenance of DB2 for i physical and logical files. It teaches many techniques that, if implemented, will enhance the performance of applications using the database. This course does not discuss in detail, the use of SQL for database management.
AUDIENCE
This course is designed for persons who will be responsible for creating and maintaining a DB2 for i database. It will also provide the necessary foundation for those persons intending to write application programs for DB2 for i.
PREREQUISITES
Before taking this course, a student should be able to:
• Use a Windows-based PC
• Navigate and use a Windows-based desktop
• Use basic IBM i navigation tools, including:
– CL commands
– Menus
– Online Help
– WRKSPLF and related commands to manage output
– WRKJOB, DSPMSG, DSPJOB commands and so forth to perform basic problem determination
• Use the Program Development Manager/Source Entry Utility or the RSE LPEX Editor to create and maintain source files
• List and explain the use of data types supported by the DB2 for i database
• Prerequisite courses:
– OE98/OE980: Introduction to IBM i for New Users
– OL49/OL490: IBM i Application Programming Facilities Workshop
OBJECTIVES
After completing this course, a student should be able to do the following:
• Create the physical and logical files required to implement a database design
• Understand the function of and create a field reference file
• Explain how choices made while coding and creating a file affect performance
• Understand the different ways to interface to DB2 for IBM i
• Perform database maintenance
• Understand the concepts of referential integrity and triggers
