Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a Physical File & a Logical?
- 28 Answers
- 112069 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
how do you know that records are locked?
What is the difference between crtdupobj and copyf?
what is join logical file?
what would be the effect on the field where reverse image, underline and highlight display attributes were active?
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?
How can we change the uppercase to Lowercase in RPG?
What is access path in as400?
can we define multi-dimensional arrays in rpg ?
can a indexed file be accessed in arrival sequence in rpg program?
what is the command to know key fields of file?
how do u compile rpgle program?
how to define to define a hidden filed in dspf ?
what is service program?
To Add A File To The 'file Selection' Option Of A Query, The Function Key To Be Pressed Is?
Apart from opening of a file do we have any other use of USROPN?
