How do you find out whether a record is present in the
physical file without reading the file?
for Example Employee No: 100 in an Employee master.How do
we find out whther 100 is present in Employee master
without reading the file?

Answers were Sorted based on User's Feedback



How do you find out whether a record is present in the physical file without reading the file? f..

Answer / samul paul

With the help of SETLL using EQ indi,we can check the
existance of record wihtout reading the file.

Is This Answer Correct ?    35 Yes 0 No

How do you find out whether a record is present in the physical file without reading the file? f..

Answer / kaka halwai

100 SETLL Employee master
IF %EQUAL(Employee master)
record is found
Else
Record is not found..
Endif

:-)

Is This Answer Correct ?    5 Yes 0 No

How do you find out whether a record is present in the physical file without reading the file? f..

Answer / rashmimalpani

You can do SETLL and then use %found to check whether the
record exist in the file.

Chain itself does the SETLL operation on the file and reads
the subsequent record if match is found.

Is This Answer Correct ?    14 Yes 11 No

How do you find out whether a record is present in the physical file without reading the file? f..

Answer / ld123q44

SETLL described by everyone above is the answer provided the
file has an index by Employee No.

Is This Answer Correct ?    3 Yes 1 No

How do you find out whether a record is present in the physical file without reading the file? f..

Answer / spmk

Hi.....
With the help of 'File information data structure'
we can find the existence of record in physical file.

Is This Answer Correct ?    4 Yes 3 No

How do you find out whether a record is present in the physical file without reading the file? f..

Answer / no

Using I spec.

Is This Answer Correct ?    1 Yes 0 No

How do you find out whether a record is present in the physical file without reading the file? f..

Answer / dinesh

hi....
do setll and then use %found if there are record
exit in file then it will display recrd

Is This Answer Correct ?    6 Yes 9 No

How do you find out whether a record is present in the physical file without reading the file? f..

Answer / prasanna

If you Request was thru program then you can do it by SETLL
else DSPPFM or DSPF command

Is This Answer Correct ?    1 Yes 6 No

How do you find out whether a record is present in the physical file without reading the file? f..

Answer / venkatesh p

*loval setll file
read recor 70

in indicator on norecords in file ,else records in file

Is This Answer Correct ?    0 Yes 5 No

How do you find out whether a record is present in the physical file without reading the file? f..

Answer / srinivas

100 chain filename
if %found
dsply the record
else
display the norerord
endif

or

Is This Answer Correct ?    1 Yes 6 No

Post New Answer

More RPG400 Interview Questions

What will happen if we r using seton lr after return or vice versa.

5 Answers  


What is the syntax of passing parameters to a procedure by value?

1 Answers  


Hi guys, anybody know How RPG/400 code can be converted to RPG IV code with a single command?

1 Answers  


How to add 2 new fields in a file? How many ways are there in as400?

2 Answers  


Q1.How to read the Array? Q2.How to copy the content of one Array to another Array?

4 Answers   IBM,






what is the equivalent keyword for CHAIN opcode ??

7 Answers   TCS,


How to find d key field of a pf that doesn’t have source physical file?

2 Answers  


How I can reread the physical file in CL program once the end of file reached in same CL program.

20 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,


How can we call CL program to RPG? How many number of parameter we can pass

2 Answers   TCS,


What will be your approach in going either for OPNQRYF or Logical files. Which one to go for?

2 Answers  


How to read data from Nth member of a physical file containing some X number of members in it? "Provided member names are unknown"

4 Answers  


Categories