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 |
When will DUMP & DEBUG be ignored?
How do you call procedures in ILE?
what do you mean by SESSION/DEVOCE ERROR?
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,
can any one help in hawkeye and turnover or any change management system plzzzzz or send the documents to my mail id :gvsp.as4@gmail.com
How many program bind in one module....
How to find d key field of a pf that doesn’t have source physical file?
what is file identifier wher we can use
How to handle duplicate error handling in RPG?
Suppose I have 3 jobs a b and c. I want to submit b after successful completion of a and want to submit c after successful completion of b. Without using job scheduler or job queue, how can I do that through cl program?
what built in function can be used with SETLL.If you want to check whether the search argument is successful or not? Please give me answer with example?
What would be the result on writing a data record to a PF file using the "WRITE" opcode after the SETON *ON *INLR statment?