
Course Description (By Curriculum)

2 to 3 hours
Personnel requiring an introduction to iSeries programming
Completion of the courses Introduction to Programming the iSeries Part 1 and Part 2, and knowledge of data processing, programming concepts, and the iSeries operating system
After completing this course, the student will be able to identify:
• Physical files, logical files, and trigger programs
• Record level access and SQL statements
• The DDS used to create physical files
• The DDS used to create logical files
Physical Files, Logical Files, SQL, and Trigger Programs
Record Level Access and Accessing DB2 UDB with SQL
The DDS to Describe Physical Files
The DDS to Describe Logical Files
Logical File Concepts
The DDS to Describe Logical Files
Use of Logical Files