Use the Locate notebook to specify criteria and search a database object
for a name inside the database, the table space, or across tables and their
supporting objects. If you are searching in index or table space
objects, you can also set search criteria to help you decide whether to run
certain utilities. Use the Locate page to specify search criteria and
use the Advanced page to further customize the search.
Fields and controls
Authorities and privileges
To locate an object defined within a database:
- Open the Locate notebook.
- From the Object type field, select
the type of database object to search. The list of objects available is
dependent on the database object you selected.
- On the Locate page use the Column,
Comparison, and Values fields to specify criteria for up to
five different catalog columns. You must either type some value in at
least one of the Values fields, including a one-character wild-card (for an
inclusive search) or specify some criteria to define a needed utility (for
index and table space objects only). To search on all objects, type the
wild-card % in a field. The strings you type in the Values column will
be folded to upper case unless delimited.
- On the Locate page select a radio button to specify whether to meet all the conditions selected in the fields
on the Locate page, or meet at least one of the
conditions.
- Optional: On the Locate page click Clear to clear the search criteria that you
defined.
- Optional: Customize your search. Select the Advanced tab to
change the WHERE clause generated
from your choices on the Locate page.
- Optional: On the Advanced page click Reset to reset the search criteria to the
values defined on the Locate page.
- Click OK to use the search criteria that you
defined. The result of your search is displayed in the Locate Result window.
- Click Apply to repeat the search with the
same or different criteria.
Related information