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

There are six records in a file and we are going to update that records and used commit operation when it complete the update but suppose when it updating the third record,a error occured and operation failed.Is previously two records will be update or whole operation will be rollback? Please confirm it.

2 Answers  

---

How to insert more than one record to a pf at a time?(Bulk insert to a pf)

9 Answers  

---

How to read a PF in reverse(from last rec to first) using CL?

3 Answers   HCL,

---

how can i know logical file belongs to which physical file without source?

4 Answers   Cap Gemini,

---

how to restrict upon adding the data for field reference file in DB400

1 Answers  

---

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

7 Answers  

---

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

1 Answers  

---

Can we concatenate fields in physical file? If yes how can we do?

0 Answers  

---

What is the interactive job? What is the batch job? How to change the batch job to interactive job?

0 Answers  

---

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

3 Answers  

---

How many maximum record format a logical file have?

0 Answers  

---

When u create a PF and did not fill up Maint parameter, then by default which access path will the system take & why

2 Answers   HCL,

---