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
 

 

Why shoud we use READ LOGICAL instead of FIND?

 
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: Fri Dec 23, 2005 5:24 pm    Post subject: Why shoud we use READ LOGICAL instead of FIND?
Reply with quote

Hi Frens:

Both the READ LOGICAL and FIND are useful in someway or other way.
But my DBA told me to use READ LOGICAL instead of FIND?
Can anyone plz clarify the significance of this instruction?
Back to top
View user's profile Send private message

Dariusz
Warnings : 1

New User


Joined: 11 Aug 2005
Posts: 27
Location: POLAND

PostPosted: Fri Dec 23, 2005 5:42 pm    Post subject: FIND when possible only !
Reply with quote

Hi.
Find is more usable bycause it runs by ADABAS and it is quickly.
There is one problem only:
for FIND WITH .... we need descriptor field,but too much descriptors
is not better for quick working.
Regards.
Back to top
View user's profile Send private message
toughmetals

New User


Joined: 10 Jan 2006
Posts: 14
Location: India

PostPosted: Mon Jan 16, 2006 12:30 pm    Post subject:
Reply with quote

Hi,

Their is quite difference in processing of READ and FIND.

FIND:
1. Search the inverted list for Descriptor value
2. Build a list of ISN with the matched value
3. Process the ISN thru address converter to fetch the physical record
4. Repeat 3. until ISN list exhaust


READ Logical:
1. Search the inverted list >= Descriptor value and get the ISN
2. Process the ISN and get the actual record
3. Repeat 2. until Inverted list exhaust or u'll get some escaping criteria.

You see, the difference lies here is building of ISN list in case of FIND in working storage. Which is overhead.

Next major difference is we use READ logical only in case we want to get the data sorted by some descriptor value. Whereas, FIND will give us the data in order ISN site in the inverted list.
Back to top
View user's profile Send private message
Borebeat

New User


Joined: 16 Jan 2006
Posts: 7
Location: Coimbatore

PostPosted: Mon Jan 16, 2006 11:59 pm    Post subject: Read and Find
Reply with quote

Its better to think of READ as for SEQUENTIAL READ and FIND for RANDOM ACCESS.
Back to top
View user's profile Send private message
toughmetals

New User


Joined: 10 Jan 2006
Posts: 14
Location: India

PostPosted: Tue Jan 17, 2006 9:29 am    Post subject:
Reply with quote

Hi BB,

"FIND for RANDOM ACCESS". Could you pls give me some examples?

So that we will be more clear.
Back to top
View user's profile Send private message
Borebeat

New User


Joined: 16 Jan 2006
Posts: 7
Location: Coimbatore

PostPosted: Tue Jan 17, 2006 11:33 pm    Post subject: Re: Why shoud we use READ LOGICAL instead of FIND?
Reply with quote

FIND do not actually read the database; ISNs are read directly from the Associator's inverted lists.

READ commands are used to read actual records from Data Storage. Depending on the specified command and its options, records are read individually

1. in the sequence in which they are stored; (READ PHYSICAL)

2. in the order of an ISN list created by one of the database query commands; or (READ BY ISN)

3. in logical sequence according to a user-specified descriptor. (READ LOGICAL)


FIND is faster than READ !!!! :-)
Back to top
View user's profile Send private message
toughmetals

New User


Joined: 10 Jan 2006
Posts: 14
Location: India

PostPosted: Fri Jan 20, 2006 1:59 pm    Post subject:
Reply with quote

Hi BB,

After Fetching ISN from the Inverted list it will go to Address converter to take the RABN number, after that it will get the actual record from DATABASE.

Only Histogram will not get into the DB and read the information only from Inverted List.

Thanks,
Deeps
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