Difference between Physical file and Logical file in AS400

Difference between Physical file and Logical file in AS400
Difference between Physical file and Logical file in AS400, difference between PF and LF, difference b/w PF and LF,difference,between,physical file,logical file,example,introduction,about,what is,what,difference between physical file and logical file,as400,in as400
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.

Physical File Logical File
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
physical file.
Use the DSPFD command on the Logical files to find the
parent physical file on which the LF is based.

Post a Comment

© AS400 and SQL Tricks. All rights reserved. Developed by Jago Desain