Table of Contents
IBM DB2 for iSeries - Physical and Logical Files
A physical file is a database file that stores data. It also contains a description how data is actually stored in the database.
From the perspective of the SQL standard, physical files are identical to tables.
- File Member
Physical files can contain one or more members. Members are different sets of data, each with the same format, within one database file (SQL table).
A record is a group of related data within a file. From the perspective of the SQL standard, records are identical to rows.
A logical file is a database file that logically represents one or more physical files. Logical files do not contain data records, but they define record formats. The data records are contained in the physical files associated with the logical files.
Logical files let users access data in a sequence and format that is different from the physical files they represent.
From the perspective of the SQL standard, logical files are identical to views and indexes.
A source file contains source statements for high-level language programs and data description specifications (DDS).