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 |
IN RLU what are the record level keyword is used?
1.The questions have given an array declaration and move operation then this statement is correct or not?
during execution, an rpg/400 program automatically follows a sequence of operations for each record that is processed. The built-in program cycle includes the following logical steps.
What are the types of identifiers?
wat is scan and check ? give me real time scenarios where we used these keywords in ur projects?
I have a Physical File name 'File1', which is present in two libraries named 'LIB1' & 'LIB2'. These 2 libraries are listed in the library list. Would like to access data from this file from these two libraries using RPG program. How to do this, any idea?
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
Hi friends, I am using a load all subfile , and currently i am in in the third page of the subfile , from third page i have selected a record and called some other program .on returning, subfile is being loaded from the frist page. so can any one kindly suggest me in retaining my third page after returning. i.e loading from third page.
how can we find setll setgt chain read reade readp operations are successfull or not,give example.explain in detail.
Mr.Yallamanda Reddy P thanks for your answer sir,can we use test(D) opcode in RPG/400,if yes please help me by eloborating on that answer by writing a sample code for that sir
If record-format name in an externally-described file has already been defined as a file-name.how to solve this?
How to check which are the pgms using 1 perticulate file.? I know there is many tool available for X-reference...but need to know is there any command available in the system...?