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...

records can be read/update/deleted with which file?

828

---

what is the favicon.ico request that my site receives now and then?

844

---

define the purpose/use for sflrna?

1292

---

What is file access opcodes?

1000

---

what is the difference between seton lr and retrn?

1570

---

---

What is difference between rename and prefix?

752

---

how to toggle between single line and multi - line display of a particular record in a subfile?

1387

---

when should I use method get, and when should I use method post in my cgis?

796

---

Difference Between Source Physical File & Physical File?

843

---

what are all the contents of subfile?

1242

---

if dspatr(pc) and csrloc were specified for a format, which keyword would have priority?

1302

---

Difference Between Ca & Cf?

853

---

which are the relational operators in rpg?

860

---

what opcode could be used to test an alphanumeric field for all numeric values?

1394

---

What is compiler directive in as400? Give example of compiler directive.?

748

---