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. |
Step 2—Specifying driving table selection criteria
The following figure is displayed when you enter Yes in the Edit Object Selection Criteria field on the Extract - DB2 Driving Object screen.
Driving Object Selection Criteria
Command ===> END SCROLL ===> CSR
Specify selection criteria for table FRSAMP.ORDER_TABLE
Column Name Type(Length) Where More: >
- -------------------- ------------------ ----+---10----+---20----+---30---
P ORDER_NUMBER CHAR(6)
CUST_NUM CHAR(6) ='CW3375'
SOC_SEC_NUM CHAR(11)
CREDIT_CARD_NUM CHAR(16)
ORD_TYPE CHAR(8)
ORD_DATE DATE
ORD_STAT CHAR(8)
ORD_AMOUNT DEC(9,2)
ORD_DEPOSIT DEC(9,2)
ORD_LINE_COUNT INTEGER
SHIP_CODE CHAR(2)
SHIP_DATE DATE
ORD_DESCRIPTION VCHAR(100)
** End of Columns **
To specify the driving table selection criteria: | |
---|---|
In this field… | Do the following: |
Where | Type = ‘CW3375’ for column CUST_NUM |
Command | Type the END primary command. |
Press Enter | File-AID/RDX submits the extract job (remember you entered GO in the Extract - DB2 Driving Object screen) and returns to the Primary Option Menu. When the extract is completed you will receive a message with a completion code. You can then preform a load or delete using the resulting extract file. You must use the NEW command in the Load or Delete Reference List to access the extract file as extract files from a Single Panel extract are not placed into the reference lists (see also NEW (N)). |
Field Names and Descriptions
The following list describes the fields on this screen.
FIELD | DESCRIPTION |
---|---|
Key/Index Indicator | (Untitled 1 byte field) Indicates P Primary key, F Foreign Key, or I High Order Index key (if not Primary or Foreign) for the column as an aid for users to create SQL that will perform well. |
Column Name | Displays the names of the columns of the driving object. |
Type(Length) | Indicates the data type of each column in the driving object. |
Where | Identifies the operators and values to use to further define the extract selection criteria. |
Primary Commands
The following list identifies the primary commands that are available from this screen. For details on the command, see File-AID/Related Data XPERT Reference.
COMMAND | DESCRIPTION |
---|---|
CAPS ON | Switches all entered letters in the WHERE field to uppercase letters. |
CAPS OFF | Does not switch lowercase letters in the WHERE field to uppercase. |
DOWN | Scrolls toward the end of the column list by the specified scroll amount. |
END | Redisplays the Extract - DB2 Driving Object screen. |
LEFT | Scrolls toward the left of the Where column by the specified scroll amount. |
RIGHT | Scrolls toward the right of the Where column by the specified scroll amount. |
SQL | Displays the ISPF/PDF EDIT screen where you can edit or specify selection criteria using SQL syntax. |
UDTSWAP (UDTS) | Swaps the display for distinct type columns from UDT name to the built-in data type and length and vice versa. There are no operands associated with this command. |
UDTTYPE (UDT) | Lists all distinct data types (UDTs) that are part of the extract. The list displays the schema, UDT name, and the built-in data type and length. There are no operands associated with this command. |
UP | Scrolls toward the top of the column list by the specified scroll amount. |
Line Commands
There are no line commands associated with this screen.
Related topics