brainchime.com Latest Questions

Admin
Asked: 2024-10-13T05:56:09+05:30 In:

What is the multi-format logical file in AS400?

What is the multi-format logical file in AS400? How does it differ from a normal Logical file and where do we use the multi-format logical files? Provide an example of the DDS source to create a multi-format LF.

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

    A multi-format logical file contains more than one record format. Since all formats share the same RRN, their key fields must match.

    A multi-format logical file comprises two or more physical files with different record formats.

    Example of multi-format logical file: Let’s take two PFs, PF1 and PF2. Their DDS are as follows: DDS source for PF1

    A          R RFMT1                                  
A            ID            10A       
A            NAME          20A        
A            AGE            3P 0
A            ADDRESS       50A

    DDS source for PF2

    A          R RFMT2                                 
A            ID            10A
A            PHONE         10A 
A            STATUS         6A

    Let’s write the DDS source for multi-format logical files using PF1 and PF2 with record formats RFMT1 and RFMT2.

    A          R RFMT1                     PFILE(PF1) 
A          K ID
A          R RFMT2                     PFILE(PF2) 
A          K ID
A          K PHONE