What is the difference between SEARCH and SEARCH ALL ?
SEARCH - is a serial search. SEARCH ALL - is a binary search & the table must be sorted ( ASCENDING/DESCENDING KEY clause to be used & data loaded in this order) before using SEARCH ALL.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What is the difference between search record and add search record 17.11.08
Search Record: Specify the search record for the component.The search record controls access to rows of data in a table, and its keys and alternate search keys...What is the difference between SEARCH and SEARCH ALL ? What is more efficient ? 02.09.08
SEARCH is a sequential search from the beginning of the table. SEARCH ALL is a binary search, continually dividing the table in two halves until a match is foun...What is the difference between a binary search and a sequential search ? What are the pertinent COBOL commands ? 02.09.08
In a binary search the table element key values must be in ascending or descending sequence. The table is 'halved' to search for equal to, greater than or less...What is the difference between index and subscript ? 27.08.08
Subscript refers to the array occurrence while index is the displacement (in no of bytes) from the beginning of the array. An index can only be modified using P...What happens if you don’t specify a search record for a component ? 12.08.08
Fist thing, if the search record is not specified then the editor will not alow us to save. Secondly, if the rquirement itself demands to skip the search rec...What is the difference between SEARCH and SEARCH ALL What is more efficient ? 07.08.08
SEARCH is a sequential search from the beginning of the table. SEARCH ALL is a binary search, continually dividing the table in two halves until a match is foun...What is the difference between a binary search and a sequential search What are the pertinent COBOL ? 03.08.08
In a binary search the table element key values must be in ascending or descending sequence. The table is 'halved' to search for equal to, greater than or less...What is the difference between SEARCH and SEARCH ALL ? 31.07.08
SEARCH - is a serial search. SEARCH ALL - is a binary search & the table must be sorted ( ASCENDINGDESCENDING KEY clause to be used & data loaded in th...What is the difference between index and subscript ? 31.07.08
Subscript refers to the array occurrence while index is the displacement (in no of bytes) from the beginning of the array. An index can only be modified using...When do you use a LIKE statement ? 28.07.08
To do partial search e.g. to search employee by name, you need not specify the complete name; using LIKE, you can search for partial string matches....