—Comparison of AS400 with SQL

—Library = Schema

—Physical file – Table

 

—Physical file is a place where we keep data originally in data base.

—A physical file can have only one record format.

—Entries will be made in following order:

1. —File Level

2. —Record Level

3. —Field Level

4. —Key field level

5. —Select/Omit Level