Answer / tulasi harideep

LF doesn't hold any data it is just an access path.Data is present in a physical file which is shown by a logical file based on its key and access paths.When there is no data in PF we cant see any data in LF as well.

Hope you got my answer

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

5 Answers  

---

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 know total no of records in pf with out using sql??????

3 Answers  

---

what is the difference between adding keys & constraints into a phisical file

6 Answers   HSBC,

---

I have a PF with out any data but the dependent LF is having data?

1 Answers   HCL,

---

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

2 Answers   Cap Gemini,

---

There is one string as A B C and wanted to display string as Shri A Shri B Shri C, how we can do this in sql? If we have around 100 values in string like this, each value should be displayed with initials as Shri.

0 Answers  

---

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

9 Answers  

---

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

0 Answers  

---

Can anybody tell why Journalling is compulsary before Commitment Control?

2 Answers  

---

In a CL Program after executing a SQL SP how to receive a Output value from the SP. Just to make it clear I am sending 2 input and 1 output parameter to the SQL Stored Procedure. Now while receiving it output parm it is failing.

0 Answers   Nous,

---

wirte a simple program for read file in cl

2 Answers   Active Brains,

---