What is the difference between a Physical File & a Logical?
Answer Posted / swagga refic
The difference between logical and physical file organisation is that in physical file organisation contains data and have only one record format where as logical file organisation is a view of physical file organisation which does not contain any data and may be based on one physical file or more than one physical file.
(N.B) Logical can be non join or join logical file. Performance becomes better if you use the logical file in the program.
Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
i am using non join multiple format my 3 database file is like that pf97 R REC ENAME ETENNO ESTATUS K ENAME pf98 R REC1 ENAME ESAL K ENAME PF99 R REC3 ENAME CRDCARD EID K EID & MY NON JOIN LOGICAL FILE IS ALSO SAME EXCEPT RECORD NAMES BEFORE I TRIED WITH 2 FILES SO ITS SAYS ERROR I.E.(Key field attributes must be same as for previous formats. ) SO I CHANGED KEYFIELD ACCORDING TO PF SO ITS WORKING BUT AFTER ADDING 3 FILES ITS SAYING SAME ERROR . I DONT KNOW I NEW IN AS400 PLLZ HELP ME I HAVE ONE MORE QUE. CANT BE USE DIFFERENT KEYFIELD (NOT ACCORDING TO PF) IN NON JOIN LOGICAL FILE.
what is procedure prototype and procedure interface.
the maximum number of subfiles that can be active for a single file is ____ .
what is the command to know key fields of file?
What is the Difference between command attention key and command function key ?
is it there an easy way to determine if an html section is available to issue a wrtsection upon?
what are the various types of device files?
what is the use of dspatr(mdt) keyword?
what is a keyed physical file?
define the rcvf command?
What is diff between EVAL & MOVE?
what is full form for dds?
under given circumstances, my cgi should link to another site. How to implement this?
Difference Between Call & Sbmjob?
what would be the effect on the field where reverse image, underline and highlight display attributes were active?