Answer / vidhya

A physical file can be joined to itself to read records that are formed by combining two or more records from the PF itself.
For example
You use a self join when a table references data in itself.

E.g., an Employee table may have a SupervisorID column that points to the employee that is the boss of the current employee.

To query the data and get information for both people in one row, you could self join like this:

select e1.EmployeeID,
e1.FirstName,
e1.LastName,
e1.SupervisorID,
e2.FirstName as SupervisorFirstName,
e2.LastName as SupervisorLastName
from Employee e1
left outer join Employee e2 on e1.SupervisorID = e2.EmployeeID

How to know the particular record in pf with out reading?

0 Answers  

---

Last statement of any RPG pgm is LR?

5 Answers  

---

can we concate fileds in physical file? If yes how can we do?

5 Answers   Patni,

---

How to add a field to a PF and compile it without loss of data?

7 Answers  

---

How to retrieve a physical file after deleting that?

0 Answers  

---

how to eliminate the level check error

2 Answers   TCS,

---

How to find the list of source physical files in a library?? Is there any way to get a list??

5 Answers   Infosys,

---

how to know total no of records in pf with out using sql??????

3 Answers  

---

can any one pls tell me some differences between a LF and command OPNQRYF?

3 Answers   Accenture, Cognizant, eFunds,

---

Suppose I have a pf, it contains 5 members, how to access particular member data from logical file? What is the use of member in pf?

0 Answers  

---

In how many ways we can create a logical file?`

5 Answers  

---

how to add a new field to a file without compiling it?

1 Answers  

---