Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a Physical File & a Logical?
- 28 Answers
- 112089 Views
- Accenture, ACS, IBM, I also Faced
- E-Mail Answers
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
which type of object is used in db2/400?
during input operation which indicator position is seton if there is a record lock?
What is RETURN CURSER LOCATION in subfile?
how will you find a string using pdm?
how do you use exceptional write in c specs?
what does check opcode do ?
how would you design the process for a nightly, high volume check producing process that needs to select only records that are flagged to be processed?
What is a query can be displayed without saving it?
define the purpose of the iter operation?
which cl command can be used at program execution to redirect the file named in an rpg program?
how to write code for singlepage in sqlrpgle with update ?
Can any one explain the basic things about RLU and Printer Files and their Definitions for both and why are they used,i'm a newbee so please help me out
different type of cursor?
what is the command used to invoke rlu ?
what is the purpose of indicators in rpg?
