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, can any one tell me :IN CASE OF SINGLE PAGE FILE HOW WILL I LOAD THE PREVIOUS PAGE WITHOUT THE USE OF SFLCLR INDICATOR ?

3 Answers   IBM,

without logical file we cannot access the data in physical file.but we specify physical file in the program(ie:- Ffile IF E k disk).how can it be accessed?

3 Answers   HSBC, TCS,

I want my simple Green screen should refersh every 1 min ,How can I do it..? Please share the logic

2 Answers  

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

1 Answers  

1. I have2 records in a PF. READ PF DO DSPLY EMPNO RETRN DSPLY EMPNO ENDDO What was the output 2. SETON LR vs RETURN 3. Primary File 4. How to delete a deleted spaces 5. How to read a PF in reverse order in CL 6. I have a object in Lib A, B and C. But it shows in D Lib..Why? 7.

4 Answers   HCL,

How many program bind in one module....

0 Answers  

how do u find whether a record is locked or not??

4 Answers   CTS,

What would be the effect on the field where reverse image, underline and high intensity?

7 Answers   IBM,

What is the RPG cycle?

3 Answers   CSC,

How to sort an array in descending in RPG

3 Answers   Google, TCS,

Please tell me how to read the records from a file with load an array of size with error conditions(The logic answer for this question is ARR is array of 99 elements Z-ADD 0 IDX *LOVAL SETLL FILE READ FILE 99 *IN99 DOWEQ *OFF IDX ANDLT 99 ADD 1 IDX MOVE FIELD ARR,IDX READ FILE 99 ENDDO).So,Please give me the complete of this code.

0 Answers  

How do I read records from Subfile? what is the purpose of READC explain with example?

4 Answers   IBM,