Relationship Facilitator

This section describes Option 6, Relationships - Relationship Facilitator. The Relationship Facilitator enables you to view and manipulate the relationship file to:

• View all relationships defined to File-AID.
• Load Db2-defined referential integrity (RI) relationships from the Db2 catalog table, SYSIBM.SYSRELS, into the relationship file.
• Refresh the relationship file when its RI information does not match the Db2 catalog.
• Delete RI and user-defined application relationship information from the relationship file.
• Add application relationship information to the relationship file.
• Modify existing application relationship information.
• Allocate a new relationship file.
• Refresh RI information using batch
• Print formatted contents of a relationship file.

Relationship File Compatibility Notes

1. Relationship files can be shared between File-AID for Db2 and File-AID/RDX.
2. Conditional Application Relationships (AR-C) cannot be created with File-AID for Db2’s Relationship Facilitator. Conditional Application Relationships defined with File-AID/RDX are treated as regular relationships in File-AID for Db2 Related Table Browse and Edit. File-AID for Db2 does NOT test for the defined conditions of Conditional Application Relationships when selecting one for Related Edit or Browse.

This section provides information about the following topics: