What is the difference between a Physical File & a Logical?
Answer Posted / sujanindian
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. We can able to update
in nonjoin logical files.In the case of join logical files
we can't able to update..
types of nonjoin(3) - simple,mulitple physical files,
multiple record format.
types of joins(3)- inner or simple join or nature join or
missing secondaries, leftouterjoin, selfjoin...
| Is This Answer Correct ? | 18 Yes | 7 No |
Post New Answer View All Answers
how many levels are there in a physical file?
define a shared access path?
what are the limitations of cl (compare to rpg) ?
define the purpose of the *bcat function?
what is service program?
what is the use of data structures?
how you get the relative record in a subfile in which cursor is located?
which are the query selection criteria, which can be given in a query?
What Is The Difference Between Goto & Exsr?
give three main purposes of file specification ?
what opcode will be used to test the zone of a character field?
can a join logical file be updated?
what is subfile?
some special characters I key in my html source members show different on my web pages. Why? How can I solve this?
what is term cua , saa?