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.

how to develop some simple graphs (bar charts) using just html?

1057

---

where can you specify an indicator in lokup operation?

1809

---

define the purpose of the leave operation?

1592

---

what is cab?

1161

---

define the purpose of the *bcat function?

1525

---

define a output queue?

1580

---

which of the cl command can be used to determine which logical files are dependent on a specific file?

1085

---

What are the types of data structure in as400?

1033

---

how you will find an error which is not in the first page of the subfile without using rolldown key?

998

---

What is a query can be displayed without saving it?

1087

---

what is the use of unique keyword and what level it is defined?

1594

---

what is a physical file?

1798

---

how to write *pssr ?

1067

---

How Many Specs Are There In Rpg & Which Are They?

1097

---

what key word is used when screen is re-display?

1126

---