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 the interactive job?

0 Answers  

---

How to index LF by relative record no (RRN)

0 Answers  

---

i have a PF,it contains 5 members,how to access particular member data from logical file ?and what is the use of member in PF

3 Answers  

---

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

1 Answers   TCS,

---

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

3 Answers   HCL,

---

When we use any keyword like FIFO,LIFO, at file level but whenever we check by runqry we couldn't find answer in FIFO,LIFO,FCFO etc so how we check the answer.

2 Answers  

---

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

0 Answers  

---

how to update physical files using normal logical file

4 Answers  

---

Is Constent can be define as a key field?

3 Answers  

---

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 can i know logical file belongs to which physical file without source?

4 Answers   Cap Gemini,

---