Use a Pattern

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.

Naming Conventions

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.

Database Table or Primary Key

The fully qualified name of a primary key matches the name of the database table for which it is defined: dbalias.creatorid.tablename

dbalias
Alias that identifies the database where the table resides (1 to 12 characters).
creatorid
Creator ID assigned to the table (1 to 64 characters).
tablename
Base table name (1 to 64 characters).
Note: When Object Security is enabled, the second and third parts of a Primary Key (i.e., the creatorid and tablename) are restricted to a combined total of 64 characters.

DB Alias

The fully qualified name of a DB Alias is dbalias.

dbalias
Base name assigned to the DB Alias (1 to 12 characters).

Access Definition

The fully qualified name of an Access Definition is identifier.name

identifier
Qualifier assigned to the Access Definition (1 to 8 characters).
name
Base name assigned to the Access Definition (1 to 12 characters).

Relationship

The fully qualified name of a relationship is dbalias.creatorid.tablename.constraint

dbalias
Alias that identifies the database where the child table resides (1 to 12 characters).
creatorid
Creator ID assigned to the child table (1 to 64 characters).
tablename
Base name of the child table (1 to 64 characters).
constraint
Name of the relationship (1 to 64 characters).
Note:
  • When Object Security is enabled, the second, third, and fourth parts of a Relationship (i.e., the creatorid,tablename, and constraint) are restricted to a combined total of 64 characters.
  • If Enforce DBMS Rel. Name Lengths is selected on the Product Options dialog Database tab, the constraint length must comply with the database management system's limit. See the Installation and Configuration Guide for detailed information on the Product Options dialog.

Table Map

The fully qualified name of a Table Map is identifier.name.

identifier
Identifier assigned to the Table Map (1 to 8 characters).
name
Name assigned to the Table Map (1 to 12 characters).

Column Map

The fully qualified name of a Column Map is identifier.name.

identifier
Identifier assigned to the Column Map (1 to 8 characters).
name
Name assigned to the Column Map (1 to 12 characters).

Request Name

The fully qualified name of a process request (for example, an Archive Request) is identifier.name.

identifier
Identifier assigned to the request (1 to 8 characters).
name
Name assigned to the request (1 to 12 characters).

Wildcard Characters

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:

dbalias.creatorid.%
List all tables identified by a specific DB Alias and Creator ID.
dbalias.%.tablename
List all occurrences of a specific table identified by a particular DB Alias, regardless of the Creator ID.
dbalias.%.%
List all tables identified by a particular DB Alias, regardless of the Creator ID.
dbalias.creatorid.TAB%
List all tables identified by a specific DB Alias and Creator ID beginning with TAB in the name.
dbalias.creatorid.TAB_
List all tables identified by a specific DB Alias and Creator ID having a four‑character name beginning with TAB.
dbalias.creatorid.T_ _B
List all tables identified by a specific DB Alias and Creator ID having a four‑character name beginning with T and ending with B.

Show Pattern for

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.

Database
List primary keys or relationships defined to a database.
Optim
List explicit and generic primary keys or relationships defined to the Optim Directory.
Both
List primary keys or relationships defined to both a database and the Optim Directory.

Relationships Related to Table

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.