Differences between READ/FIND/HISTOGRAM

monasu1998

Hi All,
I am working in a Natural/Adabas environment.

I have very brief idea about these statemsnts(in subject line).
Can someone elaborate these three statements also publish when to use whaich statement. Which is preferrable in terms of resource consuption and Adabas Calls

10X

ofer71 · Posted: Wed May 16, 2007 3:05 pm Post subject:

This is from Software-AG's fine manuals:

READ
The READ statement is used to read records from a database. The records can be retrieved from the database:

in the order in which they are physically stored in the database
(READ IN PHYSICAL SEQUENCE), or
in the order of Adabas Internal Sequence Numbers
(READ BY ISN), or
in the order of the values of a descriptor field
(READ IN LOGICAL SEQUENCE).

FIND
The FIND statement is used to select from a database those records which meet a specified search criterion.

HISTOGRAM
The HISTOGRAM statement is used to either read only the values of one database field, or determine the
number of records which meet a specified search criterion.
The HISTOGRAM statement does not provide access to any database fields other than the one specified in the
HISTOGRAM statement.

O.

ofer71 · Posted: Wed May 16, 2007 3:51 pm Post subject:

We are always looking for an experienced ADABAS/NATURAL programmers here in Israel.

Interested?

O.

verbor · New User Joined: 17 May 2007 Posts: 1 Location: Israel

Yes, I am interested.

monasu1998 · Posted: Tue May 22, 2007 10:32 am Post subject:

Hello Ofer,

Could you please let us know in what scenarios (Apart from the generic Definations) we should use READ/FIND and HISTOGRAM?

Thanks Much,

ofer71 · Posted: Thu May 24, 2007 11:09 am Post subject:

You use READ/FIND when you want to read data records from ADABAS; You usually use HISTOGRAM to count the number of records matching a specific criteria.

O.

Adam · New User Joined: 17 Jun 2005 Posts: 5

You usually use READ to read sequentially large number of records by some descriptor.
The FIND is rather for direct access to small amount of records of database.
The HISTOGRAM use only index part of database so it works quickly.
Regards

dr_te_z · Posted: Mon Aug 13, 2007 1:48 pm Post subject:

Rule of thump:

If you can obtain your data using HISTOGRAM: do so!
else
use the good old 80/20 rule:

do you need to access 20% or less from a table?
then code FIND
else code READ

Raj Kiran · New User Joined: 24 Aug 2007 Posts: 3 Location: Chennai

Read is best when there are more reords to be read.

find is best when u know the value descriptor or superdescriptor of record to be fetched

Actual usage of Histogram comes when the super descriptor is having a PE feild in such case Read and find wont work properly in this case Histogram works fine