Create Primary Keys

If you add tables to a database, you can use the Configuration program to create Optim™ Primary Keys for tables that do not have DBMS primary keys, but have unique indexes. When you create Optim Primary Keys, you must specify the Optim Directory and the DB Alias for the database where the tables are located.

Optim Primary Keys are usually created when you configure the first workstation or when you create a DB Alias. After you install Optim, you can create these primary keys by selecting Create Primary Keys from the Tasks menu, or by selecting Configuration Assistant from the Help menu.

Specify Optim Directory

Use the Specify Optim Directory dialog (see Specify Optim Directory ) to select the name of the Optim Directory. Click Proceed to open the next dialog in the process.

Create/Select DB Alias

Use the Create/Select DB Alias dialog to specify the DB Alias for the database where you want to create Primary Keys.

Example of the Create Primary Keys - Create/Select DB Alias dialog.

Create Primary Keys

You can use the Create Primary Keys and Select Primary Keys dialogs to create the Optim Primary Keys. For more information, see Create Primary Keys.

Create Primary Keys for Another?

After you create Optim Primary Keys for tables that are accessed with one DB Alias, the Configuration program prompts you to create Primary Keys for a different DB Alias. To continue, click Proceed.



Feedback