Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a Physical File & a Logical?
- 28 Answers
- 111249 Views
- Accenture, ACS, IBM, I also Faced
- E-Mail Answers
Answer Posted / godwin sf
Physical files hold the actual data of a database file. The data is written in arrival sequence.
Physical files are not required to have keyed fields. If a physical file has key fields, this is the order that an RPG program will read the data if the File Spec in the program indicates to read the data in keyed sequence.
Also, with a keyed field, an RPG program can CHAIN, SETLL, READE and READP.
A simple logical file is a different view of the physical file. It is actually a list of pointers to the physical file. Most of the time, a logical file is nothing more than a way of accessing the physical file with different key fields.
With the standard AS/400 supplied tools, it is hard to see the logical file. One way is to use the copy file CPYF to copy the logical file to a new physical file. Then, look at the physical file... it will be in the same order as the logical file.
The AS/400 Database is full featured. Logical files can join multiple files and select and create new fields.
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
difference between view and index ?
what is the purpose of ovrdta (override data) keyword?
is their a difference in cobol400 for the release 5.2 and 6.1 at the as400.
what does defn do?
Write a logic program for knowing the repeated number of a vowels in a given program?
what is scan and xlate?
define the purpose of the %sst function?
how can I give more performance to some selected pages?
what does vldcmdkey means?
what is rpg ?
what is a join logical file?
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.
maximum number of subfiles that can defined in a rpg program for one display file is?
WHAT IS AS/400 SYNORIO?
is it there an easy way to determine if an html section is available to issue a wrtsection upon?
