You can use a Pattern to search for a particular object in the Optim™ Directory or to limit the list of objects that are displayed in the Open dialog or other list. When you enter a pattern, you must use a naming convention appropriate for the object or list of objects you want to display.
When you create objects, you might want to use logical naming conventions to identify the use for each and to organize the objects for easy access. In general, Optim supports the use of _, @, #, or letters in object names and qualifiers. Numeric digits are also permitted for characters, other than the first. The naming conventions for objects follow.
The fully qualified name of a primary key matches the name of the database table for which it is defined: dbalias.creatorid.tablename
The fully qualified name of a DB Alias is dbalias.
The fully qualified name of an Access Definition is identifier.name
The fully qualified name of a relationship is dbalias.creatorid.tablename.constraint
The fully qualified name of a Table Map is identifier.name.
The fully qualified name of a Column Map is identifier.name.
The fully qualified name of a process request (for example, an Archive Request) is identifier.name.
Use percent (%) to represent any number of characters and underscore (_) to represent a single character in a pattern. (You cannot use % in identifier or dbalias and must select an option on the General tab of Personal Options to use the underscore as the SQL LIKE character.) The following examples demonstrate the use of wildcard characters to list tables with names that meet specific criteria:
When you use the Open command from the Primary Key Editor or Relationship Editor, you can further limit the list of objects by using Show pattern for options to display a specific type of object. When you select an option, the list is refreshed.
When you use the Open command from the Relationship Editor, you also can limit the list of relationships with the Relationships Related to Table options. Select the Relationships Related to Table check box to list relationships for a particular table. Enter the table name. If you do not specify the Creator ID, the default Creator ID is assumed.
Select the Show Only Directly Related Tables check box to limit the list further. If you want to display all possible relationships for the table, clear the check box.