what is open data base command

1 Answers   Active Brains, Cognizant, CSC, CTS,

---

What is the difference between access path and open data path?

0 Answers  

---

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,

---

How to know logical file belongs to which physical file without source?

1 Answers  

---

what is use of self join and which cases you will use this join

1 Answers   TCS,

---

---

How we can't update join logical files?

10 Answers  

---

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,

---

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  

---

what is multiple member pf

1 Answers   Active Brains,

---

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

6 Answers   HSBC,

---

how to see number of logical files depending on a pf?...can we declare more than 20 logical files from a single pf? is it possible

4 Answers   ocbc,

---