Types Of Read , FIND




Answers were Sorted based on User's Feedback



Answer / 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

Answer / guest

Read has the following types:
Read logical, Read physical and Reas by ISN

Is This Answer Correct ?    0 Yes 2 No

Post New Answer




More Natural Interview Questions

how we can find occurence of MU and PE fileds in a file?

2 Answers  


If the number of parameter is more than the expected then NAT0919 error is displayed. How many parameter are allowed in a CALL and CALLNAT statement?

3 Answers   JPMorgan Chase,


How converted the natural coding for adabas

0 Answers  


Does Natural online require CICS or other TP systems to function? How does Natural interact with CICS? Thanks.

1 Answers  


Describe the COBOL coding sheet

2 Answers   Cap Gemini, Royal Infotech,


The natural file converted to PDF file if Yes then explain ?

0 Answers  


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 ?

6 Answers   IBM, TCS,


what type of files we can process thru file-aid

1 Answers   Tech Mahindra,


what r the quality process in development

1 Answers  


How can I create 1 DDM that fetches 3 ADABAS files simultaneously?

5 Answers  


Types Of Read , FIND

2 Answers  


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]

1 Answers  




Categories