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
Difference Between Skip Before & Space Before?
I need to insert a record in a file using STRSQL containing the some field values same as an already existing record in that file.I know to smple insert mentioning those values one by one.But is there any another query can be prepared for the same .Please share the query if known to you. Thanks in advance.
can a single screen format occupy a screen area above and below a subfile format ?
what is the use of data structures?
how can you detect overflow for a print program that prints multiple lines per cycle?
what is a spool file?
Difference Between Call & Sbmjob?
What are the record format field mapping options in cpyf?
What is file access opcodes?
how do you specify the number of records to roll in a subfile ?
name few ibm supplied libraries?
if we tried to move year part of *iso date into a field of length 3, what will happen ?
How to reverse a string using RPG?
What Is Ddm ?
when should I use method get, and when should I use method post in my cgis?