Types Of Read , FIND

Answers were Sorted based on User's Feedback



Types Of Read , FIND..

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

Types Of Read , FIND..

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 to receive data passed through jcl parm parameter in a natural program? How data definition is defined in the program?

0 Answers  


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

2 Answers  


Explain the difference between external subroutine and subprogram?

0 Answers  


Define cobol coding sheet?

0 Answers  


how to move cursor to a particular field when position is not known?

3 Answers  






What is the difference between escape(top or bottom) and escape immediate(top or bottom?

0 Answers  


How do you pass GDA into a sub program with out PDA?

2 Answers   IBM,


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

5 Answers  


can i see the copy book length using file-aid ?

2 Answers   TCS,


how many work file we can code in jcl?

2 Answers  


Explain difference between escape(top or bottom) and escape immediate(top or bottom?

0 Answers  


COuld you please let me know along with a sample on how are you going to remove duplicates from the file that is being read. Thanks Sam

2 Answers   TCS,


Categories