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. |
User Defined Functions
There are many rules for handling User Defined Functions (UDFs). You can see them in the IBM Db2 for z/OS SQL Reference.
The User Defined Function screen (see the following figure) displays when option 8 is selected on the Object Selection Menu.
User Defined Function Screen
Option
Specify the letter of the required option:
C | Create a function. |
A | Alter a function. |
D | Drop a function. |
M | Model a function and create a new function. |
Specify UDF Information (* or pattern for list) Area
Schema Name
The name of the schema in which the new UDF should be created. This field is required. This field defaults to the SQL authorization ID if no schema is entered. Must not begin with ‘SYS’ unless it is ‘SYSADMIN’ or ‘SYSPROC’.
You can also specify a generic name with * (asterisk), or a pattern. This displays a selection window, from which you can select a specific object.
Function Name
Name of the function as it is called by SQL statements. You can also specify a generic name with * (asterisk), or a pattern. This displays a selection window, from which you can select a specific object.
Specific Name
Specific name of the UDF. If you do not provide a name, Db2 generates a unique name in the form SQLxxxxxxxxxxxx. You can also specify a generic name with * (asterisk), or a pattern. This displays a selection window, from which you can select a specific object.
Related topics