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

Answer Posted / swagga refic

The difference between logical and physical file organisation is that in physical file organisation contains data and have only one record format where as logical file organisation is a view of physical file organisation which does not contain any data and may be based on one physical file or more than one physical file.

(N.B) 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 ?    8 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how you get the relative record in a subfile in which cursor is located?

839


what does check opcode do ?

1443


what is the syntax for plist?

848


how do you pass parameters in cl?

1362


how many maximum spaces could be given in o specs?

822


how you will find an error which is not in the first page of the subfile without using rolldown key?

752


what the purpose of ovrdta, ovrata keywords?

1563


what is the version of os/400 that we have?

1268


when is a tag statement used in rpg?

1812


when would you use or not use this approach?

1199


Difference Between Ca & Cf?

870


if we tried to move year part of *iso date into a field of length 3, what will happen ?

866


explain the purpose of keep and assume keywords?

1397


what is sflinz and sflrna?

1258


during input operation which indicator position is seton if there is a record lock?

1257