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 / 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 |
Answer / srinivas
100 chain filename
if %found
dsply the record
else
display the norerord
endif
or
Is This Answer Correct ? | 1 Yes | 6 No |
What will happen if we r using seton lr after return or vice versa.
What is the syntax of passing parameters to a procedure by value?
Hi guys, anybody know How RPG/400 code can be converted to RPG IV code with a single command?
How to add 2 new fields in a file? How many ways are there in as400?
Q1.How to read the Array? Q2.How to copy the content of one Array to another Array?
what is the equivalent keyword for CHAIN opcode ??
How to find d key field of a pf that doesn’t have source physical file?
How I can reread the physical file in CL program once the end of file reached in same CL program.
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 ?
How can we call CL program to RPG? How many number of parameter we can pass
What will be your approach in going either for OPNQRYF or Logical files. Which one to go for?
How to read data from Nth member of a physical file containing some X number of members in it? "Provided member names are unknown"