Learning Center Log in Start Learning Free

← Learning Center

IBM i Fundamentals

An ordered path through the foundational IBM i concepts every beginner and working developer benefits from knowing.

Browse by category

Showing 9 of 288 lessons

6Physical Files and Logical FilesLog in to accessHow IBM i stores data in physical files and provides different views of that data through logical files.
9Introduction to Db2 for iLog in to accessWhat Db2 for i is, how it relates to physical and logical files, and how applications access the data it stores.
25DDS and SQL: Two Ways to Define Db2 for i DataLog in to accessHow Db2 for i data can be defined using either traditional DDS or modern SQL, and why both approaches still coexist today.
26Physical Files Explained in DepthLog in to accessThe structure of a DDS-defined physical file, including record formats, in more detail than the introductory lesson.
27DDS Field DefinitionsLog in to accessHow to read a simple DDS field definition: field name, data type, and length.
28Keyed Physical FilesLog in to accessWhat makes a physical file keyed, how key fields relate to DDS field definitions, and why keyed access matters.
29Logical Files Explained in DepthLog in to accessWhat logical files can do beyond reordering data: keyed ordering, field selection, and select/omit.
30Access Paths and Why They MatterLog in to accessWhat an access path is, how it supports keyed physical and logical files, and why it is a meaningful design tradeoff.
31SQL Tables vs DDS Physical FilesLog in to accessComparing an SQL-defined table directly against a DDS-defined physical file: key similarities and practical differences.