Using the Editor

The DB Alias Editor allows you to browse DB Alias names and other information that permit Optim to communicate with a specific database. You can also set defaults for objects created by Optim.

Use the options on the Defaults tabs to set defaults for creating objects. Note that Optim allows you to establish as many as three layers of default settings for the creation of database objects, in addition to target system defaults. The default settings determine the values displayed in the Object List for the Create Utility and can be overridden at the object level by editing the list.

At the broadest level, DB Alias settings, as described further on, establish defaults for creating objects in the associated database. If desired, you can provide Personal Options settings for a user or group of users that override some or all DB Alias settings. A third level of optional defaults apply at the processing level to override Personal Options and DB Alias settings. Use the options on the Defaults tabs to set first-level defaults for the Create Utility.

Note: For information on the correct syntax for entries, refer to the documentation provided with your database management system.
db alias editor general tab, explained below

Description

Text to describe the purpose of the DB Alias or provide other information (up to 128 characters).

Tabs

The DB Alias Editor includes the General, Connection, Server, Table Defaults, Index Defaults, Synonym Defaults tabs (for Oracle and Informix®), Alias Defaults tab (for DB2® CS, DB2 UDB, and DB2 MVS™), and Trigger Defaults tab.