You can use a Pattern to search for a particular object in the Optim™ Directory or to limit the list of objects displayed in the Open dialog or other list. When entering 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 may 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 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 relationship is dbalias.creatorid.tablename.constraint
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 using the Open command from the Primary Key Editoror 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 using the Open command from the Relationship Editor, you can also limit the list of relationships using 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.