|Difference between Physical file and Logical file in AS400
Difference b/w PF and LF
There are several differences between PF and LF that are listed here in this blog.
|The physical file occupies memory and has data
contained within it.
|The logical file does not occupy any memory and does not
contain any data. It's an access path.
It's a view over one or more physical files.
|CRTPF command is used to create PF objects.
|CRTLF command is used to create an LF object.
|The physical file can exist independently.
|A logical file cannot exist independently.
Physical file existence required.
|The physical file can exist alone.
|A logical file cannot exist with the existence of a physical file.
|The physical file can have only one record format.
|The logical file can have up to 32 record formats.
|The physical file cannot be deleted if any dependent
A logical file (LF) exists over it.
|The logical file can be deleted without having the need
to delete the physical file (PF).
|Use the DSPDBR command on the physical files to
find all the dependent Logical files (LF) over the
|Use the DSPFD command on the Logical files to find the
parent physical file on which the LF is based.