 |
| SQL versus traditional file access term |
There are two ways with which we can access DB2 tables and their data and they are SQL and system file access methods. Let's discuss the similar term used for SQL and traditional file system.
| SQL | Traditional File Access |
|---|---|
| Schema | Library |
| Table | Physical file |
| Row | Record |
| Column | Field |
| View/Index | Logical file(Non-keyed/Keyed) |