| SQL adaptation guide For IBM DB2 UDB 8.x, 9x / Connecting to DB2 OS/400 | |
On OS/400® machines, the DB2 Universal Database™ is integrated to the operating system. Therefore, some concepts change. For example, the physical organization of the database is quite different from UNIX™ or Windows™ platforms.
| SQL Terms | DB2 OS/400 Terms |
|---|---|
| Table | Physical file |
| Row | Record |
| Column | Field |
| Index | Keyed logical file, access path |
| View | Non keyed logical file |
| Schema | Library, Collection, Schema (OS/400 V5R1 only) |
| Log | Journal |
| Isolation Level | Commitment control level |
A Collection is a library containing a Journal, Journal Receivers, Views on the database catalogs.