Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 11 Answers
- 29461 Views
- Bank Of America, CSC, IBM, I also Faced
- E-Mail Answers
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 |
How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?
please guys help me,I need to write a program that shows more than one way to display a subfile. Both views are of the same file but sorted differently and show different fields of the same file when the user presses a function key. send me code
What is a record lock error?
WHAT IS MONMSG IDENTIFIER FOR STRTCPFTP command IN cl (as/400)?
How to code Page up and Page down in RPG for Single page subfile without using ROLLUP/ROLLDOWN in DSPF ?
What is the length of Signature?
what is the use of sflnxtchg?
Can we have a Physical file without any member ? Please let me know
How can we search particular records from the database file in RPG. For example, there are 100 records in the file.i need to retrieve all the records matching/equal to the particular 'NAME' field. How can we do the above using SEARCH criteria other than using the IF cond?
Need a sql query: retrieve all duplicate records in table?
How to create a key field for a logical file inside RPG?
The PGMA calls PGMB.PGMB generates a report.The report should contain the called program name(PGMA).How do i get the called program name in PGMB to print it on the spool file?(calling program name should NOT be hard coded or passed as parameter to called program?
RPG400 
