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 the necessary keyword for non-join logical file?
which cl command is used to trap error messages during program execution?
how to define to define a hidden filed in dspf ?
is it possible, in the same cgi, to run more than one gethtml or gethtmlifs?
how will you display a particular page in subfile ?
how can you check for a records existence without causing and i/o (chain/read)?
how may a cgi control duplicate inputs?
what does opcode post do ?
WHICH REPLY CODE IS USED BT sftp ? ... (e.g.226 is used by FTP IF FILE IS TRANSFERED)
when do you explicitly open files and close files in an rpg program?
different type of cursor?
what is the function of rlu ?
how many files, printer files you can describe in a rpg?
How we will get issues on AS/400 technology ? I mean which issue/Defect Tracking tool is using in all companies when any issue comes? Can anybody explain about the work flow of AS/400 project ? plzzz
In RPG How to read a records from a file without using read opcodes?