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. |
Generating SQL statements
File-AID for Db2 Object Administration quickly generates SQL statements based on existing objects or defaults from your user profile. This section shows you how to create a table and a primary index based on attributes acquired from a similar object. The steps require you to first display a definition for a similar object. You then edit the attributes and rename the definition. File-AID for Db2 Object Administration generates the DDL from this new definition. This process of creating can be used for the following objects:
- Aliases
- Databases
- Indexes
- Storage groups
- Synonyms
- Tables
- Tablespaces
- Triggers
- Views.
Other methods can be used to create objects, as discussed in More about Creating Objects.
When you finish this section, you’ll have a new table named EMPTEST and a new index named XEMPTEST1. You’ll use EMPTEST in the next section to grant and revoke privileges.