Locatable object types vary depending upon where Locate is invoked, as shown in this table:
|
Locate invoked from |
Locatable object types |
|
Subject Areas folder, Processes folder |
step, file, table, view, column |
|
Warehouse Sources folder |
file, table, view, column |
|
Warehouse Targets folder |
file, table, column |
|
Tables folder |
table, column |
|
Views folder |
view, column |
|
Files folder |
file, column |
|
Subject area instance, process instance |
step, file, table, view, column |
|
Warehouse source instance |
file, table, view, column |
|
Warehouse target instance |
table, column |
|
Warehouse Schemas folder, warehouse schema instance |
table, column |
The following table shows the columns that can be located for each object type:
|
Object type |
Columns |
|
Step instance (not shortcuts) |
Name, Modified, Mode, Administrator, Description |
|
Column instance |
Name, Data type, Length, Precision, Scale, Description |
|
Table instance |
Name, Schema, Table space, Index table space, Data capture, Business name, Description |
|
View instance |
Name, Schema, Data capture, Business name, Description |
|
File instance |
Name, Description |
Name: The name of the object. The default comparison operator for this attribute is LIKE. You can specify up to a 64,000 characters for a name in the associated Values field.
Length: The total number of characters in a column, applicable to columns only. The default comparison operator for this attribute is =. The LIKE and NOT LIKE comparison operators are not applicable to length.
Precision: The total number of digits in a column, applicable to columns only. The default comparison operator for this attribute is =. The LIKE and NOT LIKE comparison operators are not applicable to length.
Scale: The number of digits to the right of the decimal point in a column. The default comparison operator for this attribute is =. The LIKE and NOT LIKE comparison operators are not applicable to length.
Data type: The type of data for which you want to search, available for columns only. The default comparison operator for this attribute is LIKE.
You can search for any ODBC data types that the Data Warehouse Center supports. The Data Warehouse Center supports Informix data type conversions, Microsoft SQLServer data type conversions, Oracle data type conversions, Sybase data type conversions, and DB2 data types.
Description: A description for the object. The default comparison operator for this attribute is LIKE. You can specify up to 64,000 characters of description text in the associated Values field.
Modified: The date and time the object was last modified. The allowable comparison operators for this attribute are = and <>. The default comparison operator is =.
Mode: The status of a step, applicable to steps only. The default comparison operator for this attribute is =. You can type either development, test, or production in the associated Values field.
Administrator: The name of the administrator for a step, available for steps only.
Schema: A prefix (or qualifier) under which a table is created, available for tables only. The default comparison operator for this attribute is LIKE. You use a schema to group a collection of related tables logically. For example, in the tables IWH.PAYROLL, IWH.SALES, and IWH.EXPENSES, the schema is IWH.
Table space: The name of a table space, available for tables only. The default comparison operator for this attribute is LIKE.
Index table space: The name of an index table space, available for tables only.
Data capture: Indicates whether the table or view is enabled for replication. The allowable comparison operators for this attribute are = and <>. The default comparison operator is =. You can type Yes or No in the associated Values field.
Business name: The name given to a table that identifies it for business users, available for tables and views only.
The allowable comparison operators for each locatable object are shown in this table and described below:
|
Column |
Allowable comparison operators |
|
Name, Administrator, Description, Data type, Schema, Table space, Index table space, Business name, Description |
LIKE, NOT LIKE, =, <>, <, <=, >, >=, IS NULL, IS NOT NULL, BETWEEN, NOT BETWEEN, IN, NOT IN |
|
Length, Precision, Scale |
=, <>, <, <=, >, >=, IS NULL, IS NOT NULL, BETWEEN, NOT BETWEEN, IN, NOT IN |
|
Mode, Modified, Data capture |
=, <> |
LIKE
Use this operator to specify a character string that is similar to one that you want to find. For example, you might enter %Dept% to search for an object with the character string Dept in the name. LIKE is the default operator used for the character string attributes (Name, Data Type, Schema, and Table Space). Use % to indicate a wildcard that represents 0 or more characters. Use _ to indicate a wildcard that represents 1 character.
LIKE is not available for the length attribute.
NOT LIKE
Use this operator to specify a character string that is not similar to the one that you want to find. For example, if you want to exclude from your search a column containing the characters DEPT, you might select the NOT LIKE operator and enter %Dept% in the Values field. Use % to indicate a wildcard that represents 0 or more characters. Use _ to indicate a wildcard that represents 1 character. NOT LIKE is not available for the length attribute.
=
Use this operator to search for attributes that match the value that you specify in the Values field.
<>
Use this operator to search for attributes that are not equal to the value that you specify in the Values field.
<
Use this operator to specify attributes that are less than the value that you specify in the Values field.
<=
Use this operator to specify attributes that are less than or equal to the value that you specify in the Values field.
>
Use this operator to specify attributes that are greater than the value that you specify in the Values field.
>=
Use this operator to specify attributes that are greater than or equal to the value that you specify in the Values field.
IS NULL
Use this operator to specify columns that contain null values.
IS NOT NULL
Use this operator to specify columns that do not contain null values.
BETWEEN
Use this operator to specify column length values within a specific range. For example, to find column lengths between 1 and 5, specify 1 and 5 in the Values field.
NOT BETWEEN
Use this operator to specify column length values outside of a specific range. For example, to find column lengths in outside of the range 1 and 5, specify 1 and 5 in the Values field.
IN
Use this operator to specify a column length value that is in a group of several listed values. For example, to find column lengths of 3, 5, and 9, specify 3, 5, 9 in the Values field.
NOT IN
Use this operator to specify a column length value that is not in a group of several listed values. For example, to find column lengths other than 3, 5, and 9, specify 3, 5, 9 in the Values field.
If you are searching for a column with a specific length, it is not necessary to enclose the integer values in quotation marks. If you are searching for a character string value, you can enter the value in uppercase, lowercase, or mixed case. You do not need to enclose the value in quotation marks except for the following comparison operators:
BETWEEN, NOT BETWEEN: You must enclose each value in single quotation marks. For example, if you are searching for column names between the letters q and z, select between and type q and z in the Values field.
You must include AND in the value field. You can type the word AND in either uppercase, lowercase, or mixed case.
IN, NOT IN: You must separate values with a comma. For example, if you are searching for columns that contain data types that are not characters or integers, select the NOT IN operator and type 'integer', 'char', in the Values field.
If a string contains quotation marks, you must enclose it with another set of single quotation marks. For example, if you are searching for a step named 'step3', select the = operator and type 'step3' in the Values field.
If you select the IS NULL or IS NOT NULL operator, you can type text in the Values field, but the Data Warehouse Center ignores it because the field is not applicable to those operators.
Use commas within a field to specify more than one value. The Data Warehouse Center interprets the comma as an OR operator, and will return the objects that match each of the values that you specify.