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
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 |
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 |
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 |
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 |
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 |
Answer / srinivas
100 chain filename
if %found
dsply the record
else
display the norerord
endif
or
Is This Answer Correct ? | 1 Yes | 5 No |
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 |
*loval setll file
read recor 70
in indicator on norecords in file ,else records in file
Is This Answer Correct ? | 0 Yes | 5 No |
steps for debugging two rpg programs????
What is the OPEN and CLOSE accesspath?
How to change the name of physical members Dynamically?
steps involved in debugging and types of debugging modes?
When will DUMP & DEBUG be ignored?
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?
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?
when will come session device error?
what happens when sflsiz = sflpag? What are the advantages and disadvantages?
Setps to create .csv file on IFS folder in AS/400( V4R3)....?
1.I have a Batch job, Running for 4 hours, i want to reduce the executing time to 2 hours what should you do?
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?