Answer / Rukmani

In DB400, the Primary File (PF) refers to a data file containing the base or original data. It serves as the foundation for all other files like secondary indexes and alternate indexes.

Hi, Please give the answer to this question? I have Phisical file with 100 records,there is no any duplicate records in this pf.Based on this pf one Logical file i have used.But this lf is viewing only 80 records only of that pf?What is the reason for this?Please give me answer?

4 Answers   IBM,

---

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 retrieve a physical file after deleting that?

1 Answers  

---

can any one tell me what is meant by PSSR? Kindly elaborate it...

1 Answers  

---

How to index LF by relative record no (RRN)

1 Answers  

---

how to update physical files using normal logical file

4 Answers  

---

one physical file can have how many max of logical files? what is the primary file?

3 Answers   Four soft,

---

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

5 Answers   Patni,

---

Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the concern is can the size of the file changes or it remains the same... kindly help me out with thorough xplanation.... Thanks in-advance...

6 Answers   ABC, TCS,

---

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.

1 Answers  

---

what is error handling concepts in cl

3 Answers   Active Brains,

---

Last statement of any rpg program is lr?

1 Answers  

---