Answer Posted / vaiv20

LF creates a new object in the system while that is not the
case for OPNQRYF.
LF creates a permanent data access path to the physical
file that will be updated as and when and add,update and
delete operation is performed on file Whereas OPNQRYF
creates a temporary access data path that is shared by high
level pgm for further processing of recs in file.

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.

1225

---

How to read a pf in reverse(from last record to first) using cl?

1200

---

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

1023

---

What is the batch job?

1030

---

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

1050

---

What is the primary file?

1198

---

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?

1146

---

What is the interactive job? What is the batch job?

1085

---

How to change the batch job to interactive job?

1043

---

Suppose 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?

1093

---

What is the purpose of the chain and setll and setgt?

1097

---

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

1159

---

What is the interactive job?

1068

---

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.

2654

---

How to retrieve a physical file after deleting that?

1161

---