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. | |
Trigger Terminator
The Trigger Terminator screen (Trigger Terminator screen) displays when you select option 9 from the User Parms menu. It lets you specify an SQL statement terminator different than the default value (a semicolon). The ability to change the SQL statement terminator is necessary because the CREATE TRIGGER statement may contain multiple SQL statements within the trigger body, each of which must end with a semicolon.
File-AID for Db2 will override the default Db2 SQL statement terminator for the CREATE TRIGGER statement only. It is not used outside the context of the trigger.
Trigger Terminator screen
The default trigger terminator for File-AID for Db2 is the pound sign (#).
To specify no trigger terminator, enter NONE. This is not usually advised, as it can cause problems with a DDL that has more than one BEGIN ATOMIC SQL statement or more than one CREATE TRIGGER statement.
The following characters are invalid for use as a trigger terminator:
Char | Description |
|---|---|
Blank | |
, | Comma |
‘’ | Double quote |
( | Left parenthesis |
) | Right parenthesis |
‘ | Single quote |
_ | Underscore |
% | Percent |
& | Ampersand |
+ | Plus sign |
- | Minus sign |
* | Asterisk |
/ | Back slash |
= | Equal sign |
< | Less than sign |
> | Greater than sign |
| | Or bar |
a...z A...Z | Alphabet, lower case or capitals |
Restricting these characters minimizes the possibility of using a character that may exist within the SQL statement as a trigger terminator.
Related topics