Answer / syam

1. You can select some data from a big Physical File and
Fetch that data
2. You can get Grand Total from a Physical File field
beginning of the RPG program
3. You can serch a value from a PF field

Answer / zhang

use SQLRPG is not a good idea, cause it will make your
system slowdown.
but sometimes we have to use it, such like we need provide
a compound query to custom, they have some searching
condition(they can be input together or only input one of
them), and we don't know which condition will entered, in
this scenario we can't make a logical file for this query,
so we have to use SQL sentence to searching it. we can
compose a complex "WHERE " clause.

what is EXCEPT command in rpg and use

1 Answers   Active Brains,

---

how can we can we the data decimal error?how can we open such file in support

1 Answers  

---

i hav 2 logical files(L1,L2) both r derived from one physical file(P1). how can i use both the logical files in one RPG program? if yes what i have to d.

5 Answers   TCS,

---

wat is meant by hidden field , why it is used?

4 Answers   Four soft,

---

can we use cl programming to update or delete physical files

12 Answers  

---

How to update selected fields from pf without using update opcode. How to read all member in Rpg-3,without using any cl command?

8 Answers  

---

If I have a file with 5 record and that file has 2 Key field and I want to read the unique record of the file then how can we achieve it?

1 Answers  

---

Can we journel logical file and access path? Can we use commitment control for non-join L.F?

4 Answers  

---

CAN WE READ RECORDS WITHOUT USING SETLL,READ,CHAIN IN RPG?

6 Answers   Satyam,

---

How do you find whether a job is a batch job or interactive?

4 Answers  

---

how many variables can we declare in cl pgm?

13 Answers  

---

Write a program to display prime numbers between 1 to 100 using RPGLE.

1 Answers  

---