Difference between Find and Read operation in ADABAS file.



Difference between Find and Read operation in ADABAS file...

Answer / saravanan

FIND –
• Searches the records for given search criteria from inverted list, finds the list of exact matches for value provided in search criteria and gets the ISN list matches the search criteria and orders the ISN list and find the RABN using sorted ISN list and gets the exact records from data storage and displays it.
• No need to provide any condition to terminate the loop. It gets only the list of records which exactly matches given values in search criteria and displays it.

Example,

In a library, if you want to search list of book for author ‘John’, then FIND will return catalog of books written by only ‘John’ and using the catalog we randomly the find the list of books written by ‘John’ in whole library. We will not have any details about the books written by any other authors.

READ by descriptor –
• Reads the list of records from inverted list, even though it doesn’t match exactly the search criteria, it reads the next next records starting from descriptor value and gets the ISN value and gets RABN from Address converter and gets the records and displays it.
• We need to explicitly terminate the loop using escape bottom or limit the reads, as it will be keep on reading the whole file as it doesn’t look for only exact descriptor value from search criteria.

Example,

In a library, if you want to search list of book for author ‘John’, then Read by Descriptor will return catalog of books written by ‘John’ and also next author whose name is in order next to John, for example like authors ‘Jones’, ‘Kim’ whose books are also part of Read Logical as it reads the inverted list starting from descriptor value. We will have details about other author also. We need explicitly control the read using IF condition to terminate the read after author John.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More ADABAS Interview Questions

Suppose if I have updated few fields of adabas file using update command, and after that I used display to see that field get updated or not. If in display it showing nothing or record did not get updated then what can be the possible reasons?

0 Answers  


Difference between Find and Read operation in ADABAS file.

1 Answers   Cognizant,


If i have updated few fields of Adabas file using UPDATE command, and after that i used display to see that field get updted or not. If in Display it showing nothng or record did not get updated then what can be the possible reasons?

2 Answers   Satyam, TCS,


Define adabas?

0 Answers  


What are the key features of adabas database system?

0 Answers  






What is find and read operation in adabas file?

0 Answers  


what is the difference between Null compression and default compression?

3 Answers   JPMorgan Chase,


How can we initialize a variable which is a constant in a LDA. Suppose I want to declare a variable #a N1(1:7) having constant values as 1,2,3,4,5,6, and 7 for respective occurance then how can we do that?

5 Answers   TCS,


Explain the advantages of adabas?

0 Answers  


What is an Associator in ADABAS?

4 Answers  


What is adabas and why it is used?

0 Answers  


What is dbid used in adabas?

0 Answers  


Categories