Answer Posted / keshar jain

HI,
To Update physical file in RPG use opcode UPDATE.
example
FLF1 IF E k DISK
key1 Setll LF1
READ LF1
UPDATE LF1

Note: Logical file should be simeple logical file. We can't
update physical file with help of Join logical file.

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?

1102

---

What is the primary file?

1123

---

Can we concatenate fields in physical file? If yes how can we do?

1044

---

How to index LF by relative record no (RRN)

3285

---

How to find the list of source physical files in a library?

1111

---

How to change the batch job to interactive job?

979

---

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.

1175

---

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

992

---

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?

1046

---

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.

2595

---

How to retrieve a physical file after deleting that?

1107

---

What is the use of member in pf?

986

---

What is the interactive job?

1011

---

What is the batch job?

979

---

Suppose I have a pf, it contains 5 members, how to access particular member data from logical file? What is the use of member in pf?

1119

---