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
what is match field indicator?
What is data structure in as400? What is the use of data structure?
when is a tag statement used in rpg?
what does check opcode is used?
what is a primary file?
what does check opcode do ?
Using %check we are checking monika in mona what is output? What is %SCAN?
What is the use of jdftval in as400?
Explain this error: "all record formats for externally-described file abcd ignored or dropped due to error; file ignored."?
the maximum number of subfiles that can be active for a single file is ____ .
how can a message from a message file appear as a constant on the screen?
what is the use of data structures?
what is a keyed physical file?
What Does Lokup Does In Tables & Arrays?
why is the declare cursor statement is used for?