[Previous] [Next] [Up] [Top] [Edit]


search - search a table using a fast access method.


    search table [options] < keytable


The search program may be used in combination with the index program to find data rows in large tables very quickly. First the table must be indexed. Index may sort the data table or create an auxillery index file depending on how it is run. Search will use the created index to find rows in the table that match the given options.


Program Options:

Search Specification Options:

C2 is a column from the table to be searched. This is generally the indexed table. C1 is a column from the table of input keys. These are the values to be searched for. The examples are given along with the specification of each type of search option.


[Previous] [Next] [Up] [Top] [Edit]