What is the difference between a Physical File & a Logical?

Answer Posted / narender

Physical file (PF) contains the data and have only one
record format. Logical file (LF) is a view of the physical
file which does not contain any data may be based on one
physical file or more then one physical file. Logical file
can have more then one record format. Logical can be non
join or join logical file. Performance becomes better if
you use the logical file in the program.

Is This Answer Correct ?    48 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what would be the effect on the field where reverse image, underline and highlight display attributes are active ?

976


How do I remove a flag or check no. or name when a user opens too many sessions?

1764


What is file information data structure(infds) in as400?

961


What are the types of data structure in as400?

535


what are various techniques to pass parameters from one program to another?

1027






What is a query can be displayed without saving it?

661


How can we change the uppercase to Lowercase in RPG?

921


what is term cua , saa?

940


difference between view and index ?

693


how to pick up the changed records every time in a subfile after the first change made ?

996


how does the runqry show the output?

873


what is message subfile?

1037


what opcode could be used to test an alphanumeric field for all numeric values?

1057


what is subfile?

936


which type of object is used in db2/400?

638