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 / srinivas

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

or

Is This Answer Correct ?    1 Yes 5 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

Post New Answer

More RPG400 Interview Questions

steps for debugging two rpg programs????

4 Answers  


What is the OPEN and CLOSE accesspath?

3 Answers   CTS,


How to change the name of physical members Dynamically?

1 Answers  


steps involved in debugging and types of debugging modes?

1 Answers  


When will DUMP & DEBUG be ignored?

3 Answers   IBM,






Suppose my file has 10 fields and I want to make the 2nd field zeros in all records. And assume I have millions of records and I dont want to read each record and update the desired field with 0. Any other way to do this in one step operation?

1 Answers  


What is the difference between ITER and DO ? I know both are used to execute set of statements repeatedly, but what is the main difference?

2 Answers   CGI, Wipro,


when will come session device error?

4 Answers   TCS,


what happens when sflsiz = sflpag? What are the advantages and disadvantages?

0 Answers   IBM,


Setps to create .csv file on IFS folder in AS/400( V4R3)....?

3 Answers   TCS,


1.I have a Batch job, Running for 4 hours, i want to reduce the executing time to 2 hours what should you do?

5 Answers   Cap Gemini,


Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?

0 Answers  


Categories