Admin Asked: October 13, 20242024-10-13T05:56:09+05:30 2024-10-13T05:56:09+05:30In: IBM i What is the multi-format logical file in AS400? What is the multi-format logical file in AS400? Please provide the DDS source to create a multi-format LF. as400db2 Related Questions What are AS400 systems. Please provide a introduction of AS400 systems? Is there any online server available for practicing on AS400 system? What are the menus available in AS400? What is subsystem in AS400? How to copy a save file from IFS to a library? How to transfer savf from as400 to pc? How to copy ifs file to another directory? How to copy savf from ifs to pc? How to copy ifs file to physical file? How to copy save file to ifs? How to copy spool file to ifs? How to copy physical file to ifs? How to copy file from pc to IFS/ How to download spool file from AS400? How do I delete a library in AS400? How do I copy data from AS400 to excel? What is library in AS400? How to find all the source physical file available in AS400? How to find all libraries in AS400? How to change the library list in AS400? What is access path in AS400? What is the difference between source physical file and physical file in as400? how to find the source file of an object in as400? how to change record length of source physical file in as400? What is cpf4174 error in as400? What is the use of varying keyword in rpgle? What is DDS in AS400? What is the difference between PF and LF in as400? Why do we use CHGPF command in AS400? how to create physical file in as400? What are the data types supported by physical files in AS400? how to add data in physical file in as400? how to view journal entries in as400? what is the use of ovrdbf in as400? What is an array in AS400? what is a data queue in as400 and why do we use data queue? How to run stored procedure in AS400? How to resolve session and device error in AS400? how to check as400 system values? How to check triggers on a file in as400? what is level check error and How to find damaged objects in AS400? what is module in as400? How to create binding directory in as400? how to create ifs folder in as400? What is ASP in AS400? What is JOBQ and how to create a JOBQ in AS400? What is PSDS in AS400? What is SEU in AS400 and why do we use it? what is PR and PI in rpgle? Leave an answerLeave an answerCancel reply Attachment Select file Browse Featured image Select file Browse Add a Video to describe the problem better. Video type Youtube Vimeo Dailymotion Facebook TikTok Choose from here the video type. Video ID Put Video ID here: https://www.youtube.com/watch?v=sdUUx5FdySs Ex: "sdUUx5FdySs". Visual Text Save my name, email, and website in this browser for the next time I comment. 1 Answer Voted Oldest Recent Random Admin 2024-10-13T06:00:02+05:30Added an answer on October 13, 2024 at 6:00 am 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
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
DDS source for PF2
Let’s write the DDS source for multi-format logical files using PF1 and PF2 with record formats RFMT1 and RFMT2.