Answer / swetha krishna

OPNDBF

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

5 Answers   Infosys,

---

Why we create the Physical File Member?

5 Answers  

---

If we use the file level keywords like LIFO, FIFO, FCFO in a file, can we see the impact of it by doing the run query of the file? if not how can we see the impact of these keywords.

2 Answers  

---

How to retrieve a physical file after deleting that?

0 Answers  

---

what is open data path? and what is the diff b/w access path and open data path?

3 Answers   Cap Gemini,

---

I have physical 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?

0 Answers  

---

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

3 Answers   Four soft,

---

1. How can I create a LF using crtlf command based on a particular member in a multimember PF? Where I have to specify the member name? 2. How to differentiate between the types of join from a Join logical file DDS. Is it possible to have different types of Join Logical files? 3.Any performance difference between Opnqrf and Embedded SQL? When I should prefer Opnqryf and when SQL? 4. I know access path is the path chosen by the program to retrieve data. It can be of keyed access path or arrival sequence. *IMMED- *IMMED description says access path is updated each time record is added or deleted from a member. - What is updating here? *REBLD - The access path is completely rebuilt each time a file member is opened. The access path is maintained until the member is closed, then the access path is deleted. - I am not able to understand this completely. Could anyone explain these more clearly? 5.What is the purpose of using activation group. I know it is a resource allocator, but other than this any other benefits of using an activation group?

2 Answers   IBM,

---

what is general and type of general

1 Answers   Active Brains,

---

Is it possible to create a logical file whose Physical file is not in same library?

6 Answers  

---

How to retrieve a physical file after deleting that ? what is keyword used for that....??

6 Answers  

---

I have a pf, it contains 5 members, how to access particular member data from logical file?

0 Answers  

---