i have 1000 records in pf.what are all the ways to read a
particular name records in rpg?? ie.. in pf i have a name
called demo appeared around 52 times hw will we read this
particular records in rpg/400?.




Answers were Sorted based on User's Feedback



i have 1000 records in pf.what are all the ways to read a particular name records in rpg?? ie.. in ..

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.

Is This Answer Correct ?    12 Yes 1 No

i have 1000 records in pf.what are all the ways to read a particular name records in rpg?? ie.. in ..

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.

Is This Answer Correct ?    10 Yes 1 No

i have 1000 records in pf.what are all the ways to read a particular name records in rpg?? ie.. in ..

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

Is This Answer Correct ?    4 Yes 0 No




i have 1000 records in pf.what are all the ways to read a particular name records in rpg?? ie.. in ..

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

Is This Answer Correct ?    5 Yes 2 No

i have 1000 records in pf.what are all the ways to read a particular name records in rpg?? ie.. in ..

Answer / swetha

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

Is This Answer Correct ?    1 Yes 1 No

i have 1000 records in pf.what are all the ways to read a particular name records in rpg?? ie.. in ..

Answer / prasanna

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

Is This Answer Correct ?    2 Yes 2 No

i have 1000 records in pf.what are all the ways to read a particular name records in rpg?? ie.. in ..

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

Is This Answer Correct ?    0 Yes 0 No

i have 1000 records in pf.what are all the ways to read a particular name records in rpg?? ie.. in ..

Answer / deepika

setll keyfld pf1
reade keyfld pfl1
dou %eof

Is This Answer Correct ?    1 Yes 2 No

i have 1000 records in pf.what are all the ways to read a particular name records in rpg?? ie.. in ..

Answer / rajgoaj

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

Is This Answer Correct ?    0 Yes 2 No

i have 1000 records in pf.what are all the ways to read a particular name records in rpg?? ie.. in ..

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'

Is This Answer Correct ?    0 Yes 2 No

Post New Answer



More RPG400 Interview Questions

what is post opcode do

1 Answers   CTS,


Mr.Sidc sirfor my question{how to convert date format from one format to another i think in CL/400 its CVTDAT,Please tell in RPG/400 sir not in RPGILE} you have answered using MOVE opcode,can you illustrate me with a small example sir very kind of you.

1 Answers   CTS, IBM, iGate,


steps involved in debugging and types of debugging modes?

1 Answers  


How to select highest score of each subject or how to select highest income of every month?

0 Answers  


RPG/400 number of Records present in a physical file using file information data structure FPF001 IP E DISK F KINFDS INFDS1 IINFDS1 DS I *RECORD RECORD Is this coding correct sir,i have given I P E that is I- input,P-primary file,E-externally described. Primary to use RPG logic cycle,is this the correct method because we have to find number of records present using file information data structure in RPG/400 without doing any input/output operations on the file and also without using DSPFD,SQL. If the above coding is correct means,when i compile the program it gets compiled,but if i call the program it does not return anything,i need number of records,please complete the coding sir.

1 Answers   IBM,






Some times While checking MSGW for object / member / record locks ,I have seen it's locked by itself ...? How it happen and what action we need to perform if job is updating / writing a record....?

6 Answers   HSBC,


can i use unique key in LF

3 Answers   TCS,


Can any one plz explain the concept of INFSR, *PSSR, INFDS AND PSDS, I' confusing about PSDS and *PSSR, Wat is the difference btw them, wat PSDS will do????

1 Answers  


what is kids-rpg?

0 Answers   IBM,


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,


In single page subfile,if I select the mutiple options in 1 page and without pressing enter,I press rollup key (pagedown).In such case how I can handle it in rpg becasue in single page we have to handle it in pgm. It would be helpful if any one answer with coding

4 Answers   Infinite Computer Solutions,


Why did we give STRSRVJOB while debugging batch program

3 Answers   HBL Power Systems,






Categories