What are the terminology differences when working with SQL vs. the IBM i environment?
Here are some of the terms used in each environment:
SQL | IBM i |
database | system |
schema | library, journal, view |
table | physical file |
view | logical file |
index | keyed logical file |
row | record |
column | field |
log | journal |