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 the necessary keyword for non-join logical file?

1765


which cl command is used to trap error messages during program execution?

1402


how to define to define a hidden filed in dspf ?

1268


is it possible, in the same cgi, to run more than one gethtml or gethtmlifs?

1012


how will you display a particular page in subfile ?

1623


how can you check for a records existence without causing and i/o (chain/read)?

2010


how may a cgi control duplicate inputs?

1013


what does opcode post do ?

1710


WHICH REPLY CODE IS USED BT sftp ? ... (e.g.226 is used by FTP IF FILE IS TRANSFERED)

2120


when do you explicitly open files and close files in an rpg program?

2002


different type of cursor?

1017


what is the function of rlu ?

1611


how many files, printer files you can describe in a rpg?

1090


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

1641


In RPG How to read a records from a file without using read opcodes?

1484