Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

what is match field indicator?

1745


What is data structure in as400? What is the use of data structure?

1085


when is a tag statement used in rpg?

2250


what does check opcode is used?

1797


what is a primary file?

1750


what does check opcode do ?

1875


Using %check we are checking monika in mona what is output? What is %SCAN?

1679


What is the use of jdftval in as400?

1407


Explain this error: "all record formats for externally-described file abcd ignored or dropped due to error; file ignored."?

1353


the maximum number of subfiles that can be active for a single file is ____ .

1870


how can a message from a message file appear as a constant on the screen?

1599


what is the use of data structures?

1137


what is a keyed physical file?

1842


What Does Lokup Does In Tables & Arrays?

1282


why is the declare cursor statement is used for?

1065