Writer instructions | ||
Purpose | Use this page to display a banner announcement on each page of the space. Create the Space announcements page in the master space, outside of the Home branch. You can version the Space announcements page to enable different banners to be published into different target spaces, however, the banner that is displayed in the versioned (master) space itself only displays the most recently-published banner. If you find errors in the banner area of your versioned space and you are sure the Space announcements page is set up correctly, try publishing the page to the same space. For more information, see Space-announcements-banners. | |
Removing | When an announcement is no longer needed, remove the BMC Space Banner macro. | |
Translation | Localized spaces using the L10n Viewport theme must change the name of this page to Space announcements l10n. See Configuring-the-Scroll-ViewPort-theme-for-translated-spaces. | |
Usage | Choose one or none of the following BMC Space Banner macros. If your space requires another kind of announcement, you can use this page in coordination with your team lead and editors. | |
Determining relationships
To initiate a Related Table Edit session, File-AID for Db2 must determine the relationships that exist for the table you are editing. It searches table SYSIBM.SYSRELS in the Db2 catalog to determine if referential integrity relationships exist. The relationship file is searched to determine what application relationships exist. If one or more relationships are found, the relationships appear in a selection list in a window. You select the desired relationship from the window or add a new one. If no relationships are found, you have the option of creating an AR.
See Diagram of Determining Relationships for a diagram of how relationships are determined.
Using an RI Relationship
If you select an RI relationship from the window or if the only relationship defined is an RI, File-AID for Db2 must retrieve the foreign key information before it can begin the session. File-AID for Db2 uses the foreign key information from the relationship file if it is the most current information. If the Db2 catalog information is more current, File-AID for Db2 retrieves the foreign key information from table SYSIBM.SYSFOREIGNKEYS.
If foreign key information must be retrieved from SYSIBM.SYSFOREIGNKEYS, the following message displays:
To avoid getting this message, a batch job may be run to update the File-AID for DB2 relationship file. See the File-AID Single Install Image
Installation and Configuration Guide appendix on Refreshing the
Relationship File.
Once the RI information is retrieved, File-AID for Db2 automatically updates the relationship file with the new information. Updating the file enables you to keep the relationship file as current as possible and avoids future queries to SYSIBM.SYSFOREIGNKEYS. Your Related Table Edit session can now be initiated.
Using an Application Relationship
If you select an application relationship or if the only relationship defined is an AR, File-AID for Db2 has all the required relationship information from the relationship file. A Related Table Edit session can begin without any further queries.
Diagram of Determining Relationships
