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 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.

Naming conventions

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.

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 is located (1-12 characters).
creatorid
Creator ID assigned to the table (1-64 characters).
tablename
Base table name (1-64 characters).
Note: When Object Security is enabled, the second and third parts of a Primary Key (that is, 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 that is assigned to the DB Alias (1-12 characters).

Access Definition

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

identifier
Qualifier that is assigned to the Access Definition (1-8 characters).
name
Base name that is assigned to the Access Definition (1-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 is located (1-12 characters).
creatorid
Creator ID assigned to the child table (1-64 characters).
tablename
Base name of the child table (1-64 characters).
constraint
Name of the relationship (1-64 characters).
Note:
  • When Object Security is enabled, the second, third, and fourth parts of a Relationship (that is, 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. For detailed information about the Product Options dialog, see the Installation and Configuration Guide.

Table Map

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

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

Column Map

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

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

Request name

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

identifier
Identifier that is assigned to the request (1-8 characters).
name
Name that is assigned to the request (1-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 that are identified by a specific DB Alias and Creator ID.
dbalias.%.tablename
List all occurrences of a specific table that is identified by a particular DB Alias, regardless of the Creator ID.
dbalias.%.%
List all tables that are identified by a particular DB Alias, regardless of the Creator ID.
dbalias.creatorid.TAB%
List all tables that are identified by a specific DB Alias and Creator ID that begin with TAB in the name.
dbalias.creatorid.TAB_
List all tables that are identified by a specific DB Alias and Creator ID that have a four‑character name that begins with TAB.
dbalias.creatorid.T_ _B
List all tables that are identified by a specific DB Alias and Creator ID that have a four‑character name that begins with T and ends with B.

Show Pattern for

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.

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

Relationships Related to Table

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.



Feedback