Convert DBMS and Optim Primary Keys and Relationships

By default, DBMS primary keys and relationships are created as DBMS objects, while Optim™ primary keys and relationships are created as Optim objects. You can choose to change the type, however, converting certain Optim primary keys and relationships to DBMS objects and analogous DBMS objects to Optim objects.

Only Optim relationships identified as Rel, can be converted to create DBMS objects. Optim extended relationships, identified as Extended Rel, cannot be created as DBMS relationships. (Extended relationships emulate application-managed relationships and are unique to Optim; see Relationships for details on extended relationships.) DBMS foreign keys can be saved as Optim objects, however.

To convert an object, right-click the name and select Switch to DBMS Key or Switch to Optim Key.

Note: If you select Switch to Optim Key for a DBMS relationship whose name is greater than 64 bytes, Optim will truncate the name to 64 bytes (the Optim relationship maximum).