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

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

1593

---

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

1008

---

To Add A File To The 'file Selection' Option Of A Query, The Function Key To Be Pressed Is?

1161

---

what is logical file?

981

---

at what level s,o are defined and what they will do?

1694

---

Why we have multiple data types in As400 and why we use numeric, packed, decimal, zoned the basic difference between this?

1076

---

where can you specify an indicator in lokup operation?

1723

---

what is the purpose of ovrdta (override data) keyword?

1721

---

how can I predict the performance of my cgis?

1038

---

how may a cgi control duplicate inputs?

1005

---

the maximum number of subfiles that can be active for a single file is ____ .

1761

---

how can you check for a records existence without causing and i/o (chain/read)?

1996

---

which are the figurative constants used in rpg?

1268

---

define the purpose of the *cat function?

1573

---

how to write code for singlepage in sqlrpgle with update ?

2774

---