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
- 28892 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 I can reread the physical file in CL program once the end of file reached in same CL program.
what was the robotech rpg?
how we retrieve records without using key field (ex:name) from Physical File through RPG in as/400?
i would like to know under what circumstance the object will get locked on AS400.
How can we read a particular record from the database file which is not having DDS (Flat File). For example, there are 100 records in the flat file. How can we retrive 15th record in RPG/400 program (Without using CL)
As400 Command to find the Name of the Program to which a Particular Module is Bound..? Ex: IC210AMR (*MODULE) is bound with Other Modules which Forms Program Object as IC210ABP(*PGM) . As400 Command to find the IC210ABP Using IC210AMR..? Thanks
i have a file with the values 10, 20, 30, 40, if am setll with the value 25 then readp, so what it will return?
can you debug ile rpg program using isdb?
Job is in MSGW while reading the input file and writing a new record / updating a reacod due to Duplicate data error. What action would you take ( C D I R )...?
What is a record lock error?
Suppose i am having 3 programs PgmA,pgmB,pgmC and using source debugger. At debugging time i found that pgmC having some code error..then in debug mode directly how can i debug pgmC
2. Which of the following statement(s) explains the difference(s) between the /INCLUDE and ICOPY directives? a.) No difference, they function the same b.) ACOPY cannot be used as a conditional directive c.) IINCLUDE files cannot contain embedded SQL d.) Nesting /TNCLUDE directives is not allowed
RPG400 
