Answer / deepak daswani

You can use READE opcode in dow while loop to read aal the
records of PF which is 'demo'.
Because everytime cursor reads the next value in the file.

Answer / bhalchandra

What u can do is u can create a non join LF over the PF and
give the Select clause for that field like this:
S FLD1 COMP(EQ 'demo')

And now u can use this LF in your program.

Answer / swetha p rao

If the particular field value is demo , then you can do
onething to avoid reading the file unnecesarily

1. Declare a temporary file in user open mode and specify
as external mbr in F spec.

2. In CPYF there is an option to include records (INCREL )
based on selection, just copy all the records where the
field value is 'demo' in a temporary file with a create
file option. (using QCMDEXC)

3.Now the temporary file will have only demo records.Open
the file and read the records.

(or)

Using SQLRPGLE, write a query to select the records which
has field value 'demo'


Correct me if iam wrong

Answer / sudhir

to escape from creating a new object of LF(if its not a
permanent requirement) you can use OPNQRYF to select
whichever records you want like:

OPNQRYF FILE((FILENAME)) QRYSLT('(FIELDNAME *EQ "demo")')

hope you got your answer

Answer / swetha

that wud again create an object, What if the requirement
changes evrytume.then the LF wud not be useful

Answer / prasanna

In the RPG code, Move the value demo to the field and do a
reade on the file

Answer / jeganath

Go for ReadE i.e Read Equals,

give 'Demo' in Factor 1

'Demo' ReadE

it will fetch records equals 'Demo' string in the file, and
also it avoid unnecessary reading of other records, very
effective,


Note: it works only when that field is declared as key in
PF file

Answer / deepika

setll keyfld pf1
reade keyfld pfl1
dou %eof

Answer / rajgoaj

Can it be done by using group function on a SQLRPG?

Answer / rajkalyanam

Say Physical file name is PF001 and Field name is NAME
and i want to select all records having their name as DEMO
then i will use SQLRPG,please correct me if i'm wrong

Select * from PF001 where name = 'DEMO'

Hi, I am getting the error in RPG (All Record Formats for externally-described file ABCD ignored or dropped due to error; file ignored.) Please suggest any

2 Answers   Satyam,

please help me answer to this question what is the difference between the binding and srvpgm in ilerpg?

4 Answers   HCL,

difference between 1:%found and %equal built function in detail with example .

6 Answers   Polaris,

What is the compilation option that has to he specified while compiling an RPC program which uses a file having date data type field?

3 Answers   HSBC, IBM,

What is the purpose of FRCDTA keyword?

3 Answers   IBM,

wat is the difference between array and multiple occurence data structure?

4 Answers   Four soft,

suppose a job is running for 15 minutes after that it goes to message wait? what are the impact analysis

1 Answers  

Why we cannot call a service program? If I add a PEP can i call the service program?

1 Answers   DELL,

Can AnyOne tell me how to read join logical file in rpg from starting to end?

2 Answers  

ESCAPE message sent by child program can be handled by parent program using which keyword?

2 Answers  

Have a join logical file with more than one members with different record formats. So how can we read the different members from this file and also how we can read the different record format from the join logical?

3 Answers  

How can we search particular records from the database file in RPG. For example, there are 100 records in the file.i need to retrieve all the records matching/equal to the particular 'NAME' field. How can we do the above using SEARCH criteria other than using the IF cond?

4 Answers   CTS,