IBM i Operating System in more detail

Introduction to the IBM i system menu

IBM i Libraries and Objects

Library List, Types and Objects in more detail

We all know that a database stores data - but what is the difference between a Table, a Physical File, a Logical File, a View, an Index?

Let's go through a code example of creating a *PF - Physical File

Let's go through a code example of creating a *LF - Logical File

DDS Definitions for Physical File - How to Create a file with Default Values

WRKACTJOB - Work With Active Jobs

Journaling is a function which records the changes in a file in a journal. These record images are used to recover the changes in the file should the system ends abnormally. Commitment control is a function that allows you to define and process a no of changes to database files as a single unit (transaction).