In my journey of learning SQL came new terminology to me. The terminology I have used for many years felt comfortable to me, these new terms were confusing. It took a few minutes to wrap my head around the new terms.
I created a small table to use to help me navigating through these new terms.
| SQL Naming | RPG Old Programmer Naming (IBM Legacy Traditional Names) |
| Schema / collection | Library |
| Table | Physical File |
| Column | Field Name |
| Row | Record in the file |
| View | Non-Keyed Logical File |
| Index | Keyed Logical file or access path |
| Isolation Level | Commitment Control |
| Logging | Journal |
Leave a Reply