brainchime.com Latest Questions

Admin
Asked: 2024-10-13T10:13:53+05:30 In:

What is the difference between PF and LF in as400?

What is the difference between the Physical file (PF) and the Logical file (LF) in AS400? How do these files are related to each other?

How do I decide when we use PF or LF in my program?

as400db2

Related Questions

Leave an answer

Leave an answer

Browse
Browse

Choose from here the video type.

Put Video ID here: https://www.youtube.com/watch?v=sdUUx5FdySs Ex: "sdUUx5FdySs".

1 Answer

  1. Admin

    Following are the differences between PF and LF.

    1. PF stands for physical file whereas LF stands for Logical file.
    2. PF stores data in memory whereas LF does not store data in memory, it’s an access path or a view over one or more PFs.
    3. CRTPF command is used to create PF object whereas CRTLF command is used to create LF object.
    4. PF can exist independently whereas a LF cannot exist without PF.
    5. PF can have only one record format whereas the LF can contain 32 record formats.
    6. PF cannot be deleted if any LF exists over it and LF can be deleted without deleting its parent PF.
    7. The DSPDBR command is used with PF to get all dependents and the DSPFD command is used with LF to get its parent PF.