Answer Posted / niki
FIND- to access one or multiple records using search
criteria .The FIND statement has several forms. The
essential ones are as follows:
• FIND
• FIND NUMBER
FIND and FIND NUMBER are completely different - FIND
retrieves data whereas FIND NUMBER queries the database.
A FIND statement has a processing loop associated with it.
READ- to access one or multiple records with different
keys even if elements of the key are unknown. It has
multiple forms as described below:
READ PHYSICAL - when all or most of the records in the file
are to be presented
(most efficient) when the sequence of records is not
important
when there is no risk of increasing record size during
update
READ BY ISN - when some or all of the records in the file
are to be presented
when the sequence of records is not important (or ISN
sequence is required)
when there is a risk of increasing record size during update
READ LOGICAL - when some or all of the records in the file
are to be presented
(least efficient) when only records within a specific key
range are to be presented
when the sequence of records presented is important
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Explain control variable in online screens?
How to find occurrence of mu and pe fields in a file?
Explain why do we use file-aid for seqential files?
Suppose you are processing an input file in a natural program and you want the program to fail if the file is empty. What command you use in natural to force it to fail?
What is a hyperdescriptor?
Explain difference between escape(top or bottom) and escape immediate(top or bottom?
The natural file converted to PDF file if Yes then explain ?
What is the difference between escape(top or bottom) and escape immediate(top or bottom?
What is a hyperdescriptor? How does it work?
How to create 1 ddm that fetches 3 adabas files simultaneously?
What is the quality process in development?
Explain difference between read(1) and read work file once?
Explain how to find occurrence of mu and pe fields in a file?
Explain how to ftp the natural program to desktop? (From mainframe to pc), is it possible?
Explain how to receive data passed through jcl parm parameter in a natural program? How data definition is defined in the program?