Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Differences between READ/FIND/HISTOGRAM

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Java & MQSeries
View previous topic :: :: View next topic  
Author Message
monasu1998

Active User


Joined: 23 Dec 2005
Posts: 176
Location: India

PostPosted: Wed May 16, 2007 12:46 pm    Post subject: Differences between READ/FIND/HISTOGRAM
Reply with quote

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
View user's profile Send private message

ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Wed May 16, 2007 3:05 pm    Post subject:
Reply with quote

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
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Wed May 16, 2007 3:51 pm    Post subject:
Reply with quote

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

Interested?

O.
Back to top
View user's profile Send private message
verbor

New User


Joined: 17 May 2007
Posts: 1
Location: Israel

PostPosted: Thu May 17, 2007 1:41 pm    Post subject: Yes
Reply with quote

Yes, I am interested.

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

Interested?

O.
Back to top
View user's profile Send private message
monasu1998

Active User


Joined: 23 Dec 2005
Posts: 176
Location: India

PostPosted: Tue May 22, 2007 10:32 am    Post subject:
Reply with quote

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
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Thu May 24, 2007 11:09 am    Post subject:
Reply with quote

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
View user's profile Send private message
Adam

New User


Joined: 17 Jun 2005
Posts: 7

PostPosted: Wed May 30, 2007 4:08 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dr_te_z

New User


Joined: 08 Jun 2007
Posts: 71
Location: Zoetermeer, the Netherlands

PostPosted: Mon Aug 13, 2007 1:48 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Raj Kiran

New User


Joined: 24 Aug 2007
Posts: 3
Location: Chennai

PostPosted: Fri Aug 24, 2007 3:51 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Java & MQSeries All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts find particular member name in PDS us... ravi243 CLIST & REXX 10 Mon Dec 19, 2016 6:44 pm
No new posts How to find the first monday of the w... abdulrafi COBOL Programming 10 Fri Nov 25, 2016 3:24 pm
No new posts Find out a active PGM jpsager JCL & VSAM 10 Fri Oct 07, 2016 4:32 pm
No new posts CICS VSAM RLS READ akodakka CICS 3 Tue Oct 04, 2016 3:09 pm
No new posts How to find a CICS resource used in C... Arunkumar Chandrasekaran CICS 8 Thu Sep 29, 2016 1:45 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us