Types Of Read , FIND
Answers were Sorted based on User's Feedback
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 |
Answer / guest
Read has the following types:
Read logical, Read physical and Reas by ISN
| Is This Answer Correct ? | 0 Yes | 2 No |
difference between read(1) and read work file once ?
Is it possible to code GOTO statement in NATURAL? if yes please provide the syntax of the same
What is data trace system 2.0 used for?
Explain control variable in online screens?
What is a hyperdescriptor?
syntax for all WRITE COMMAND in natural language
In a Natural program i used the below code for report FORMAT LS=132 PS=60 And down the line I want to change either LS/PS like FORMAT LS=120 PS=50, is it possible? How it will work?
why do we use file-aid for seqential files?
Would like to know if have an expecific command that returns a code or something about the execution of a CALLNAT. For example ... CALLNAT 'SUBPRG' [parameter] [parameter] ... [here comes a code or command that checks if the CALLNAT was successful]
Explain is it possible to code goto statement in natural? If yes please provide the syntax of the same?
Explain difference between escape(top or bottom) and escape immediate(top or bottom?
difference between fetch , call and callnat