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

which cl command is used to trap error messages during program execution?

1469

---

different type of cursor?

1051

---

what is *iso date format?

1049

---

is there any way to dynamically merge other html scripts into a given html?

1075

---

where can you specify an indicator in lokup operation?

1815

---

what are different types of substems?

2262

---

what is the purpose of overrides?

1750

---

list some of the commonly used commands for debugging?

1630

---

what are the important factors in error message subfile ?

1012

---

Which command is used to replace CDUP command in FTP IF i WANT TO USE SFTP?

2437

---

if we tried to move year part of *iso date into a field of length 3, what will happen ?

1296

---

what is sflpag and sflsiz ?

3444

---

define the purpose of the *cat function?

1673

---

What is the difference between physical file and logical file?

1139

---

how many files can be defined in f specs?

2369

---