View previous topic :: View next topic
|
Author |
Message |
monasu1998
Active User
Joined: 23 Dec 2005 Posts: 176 Location: India
|
|
|
|
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 |
|
Back to top |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005 Posts: 2358 Location: Israel
|
|
|
|
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. |
|
Back to top |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005 Posts: 2358 Location: Israel
|
|
|
|
We are always looking for an experienced ADABAS/NATURAL programmers here in Israel.
Interested?
O. |
|
Back to top |
|
|
verbor
New User
Joined: 17 May 2007 Posts: 1 Location: Israel
|
|
|
|
Yes, I am interested.
ofer71 wrote: |
We are always looking for an experienced ADABAS/NATURAL programmers here in Israel.
Interested?
O. |
|
|
Back to top |
|
|
monasu1998
Active User
Joined: 23 Dec 2005 Posts: 176 Location: India
|
|
|
|
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, |
|
Back to top |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005 Posts: 2358 Location: Israel
|
|
|
|
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. |
|
Back to top |
|
|
Adam
New User
Joined: 17 Jun 2005 Posts: 7
|
|
|
|
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 |
|
Back to top |
|
|
dr_te_z
New User
Joined: 08 Jun 2007 Posts: 71 Location: Zoetermeer, the Netherlands
|
|
|
|
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 |
|
Back to top |
|
|
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 |
|
Back to top |
|
|
|