Locate -- Fields and Controls

Object type field
Column field
Comparison field
Values field
Reset button

Object type

Select the type of object to search for. The available objects depend on the starting point of your search. At the subsystem level, all of the database objects in the object tree are available to search. The column fields on this Locate page adjust according to the object type selected.

Column

You can specify one catalog column for each of the five Column fields to be used in the search. The selected columns can even be the same with different values to search for. But, you are not limited to these five columns because of the additional changes you can make using the Advanced page of the Locate notebook.

Comparison

Specify an SQL operator to help define the query. Click on the arrow to display all the SQL operator choices. See SQL operators for more information on the choices.

Values

Specify the value or values to use in the comparison. The search is case sensitive. Multiple values must be separated by a comma, with each set delimited with a set of single quotes. Multiple values are generally used in an IN or NOT IN statement. In a LIKE comparison, you can use the % wildcard character to match 0 or more characters; or, you can use the_ wildcard character to match exactly one character. For example:

Reset

If this button is enabled, you have made changes to the WHERE clause that was generated from the Locate page of the Locate notebook, and the generated clause will not be used in the object search. The changes you make on the Advanced page become your new WHERE clause. Select the Reset button to revert back to the generated WHERE clause from the Locate page of the Locate notebook.