Add user-defined relationships in your map

When you have relationships that are defined by your programs, you can create a user-defined relationship in Database Navigator, so that your relationship is displayed in the map. An example of this might be creating a user-defined relationship to remind programmers of an important join between two tables.

To add user-defined relationships to a map:

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases.
  3. Click Database Navigator Maps.
  4. Double-click the map that you want change.
  5. Right-click the map and select Create.
  6. Select User-Defined Relationship.
  7. Type a Name and a Description for the user-defined relationship. Unlike some System i Navigator functions where the description is optional, it is important to provide a meaningful description for your user-defined relationship, since it is the only way for you to indicate what the user-defined relationship represents.
  8. Select the objects that you want to include in the relationship by selecting from the list of objects.
  9. Choose the Shape and Color you want for the object.
  10. Click OK.