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. | |
Object Selection Criteria specification
The following figure is displayed when the selected driving object on the Object Selection Criteria screen is a Db2 table or view.
Object Selection Criteria specification
Command ===> SQL SCROLL ===> CSR
Set 1 of 1
Specify selection criteria for table FRSAMP.ORDER_TABLE
Column Name Type(Length) Where More: >
- -------------------- ------------------ ----+---10----+---20----+---30---
P ORDER_NUMBER CHAR(6) > 'FF0000'
CUST_NUM CHAR(6)
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 > (greater than symbol), followed by a space, and the string ’FF0000’ |
Command | Type the SQL primary command. |
Press Enter | File-AID/RDX displays the File-AID/RDX Generated SQL screen. |
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 column extract 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 Selection Criteria Specification 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 | 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 | 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.
SQL Edit Screen
The following figure is displayed when you enter the SQL primary command on the Object Selection Criteria specification or Table Selection Criteria screen.
Only the WHERE clause of the SQL statement is displayed as you cannot modify any other part of the SQL statement for selection criteria. It displays only the WHERE clause of the SELECT statement. File-AID/RDX will create the remainder of the SQL statement.
SQL Edit
COMMAND ===> END SCROLL ===> HALF
*NOTE*
*NOTE* All Columns will be extracted FROM DSNLOCAT.FRSAMP.ORDER_TABLE
*NOTE*
****** ***************************** TOP OF DATA ******************************
000001 WHERE ORDER_NUMBER > ’FF0000’
****** *************************** BOTTOM OF DATA *****************************
To redisplay the Driving Table Selection Criteria screen: | |
|---|---|
In this field… | Do the following: |
COMMAND | Type the END primary command. |
Press Enter | File-AID/RDX displays the Driving Table Selection Criteria screen from which you invoked the SQL command. |
To redisplay the Selection Criteria Specification screen after completing all driving table selection criteria: | |
|---|---|
In this field… | Do the following: |
COMMAND | Type the END primary command in the Driving Table Selection Criteria screen. |
Press Enter | File-AID/RDX displays the Selection Criteria Specification screen. |
Field Names and Descriptions
This is an ISPF/PDF edit screen. For more information about this screen, see IBM ISPF/Program Development Facility Reference.
Primary Commands
ISPF edit primary commands are valid on this screen. For details on each command, see IBM ISPF/Program Development Facility Reference.
Line Commands
ISPF edit line commands are valid on this screen. For details on each command, see IBM ISPF/Program Development Facility Reference.
Related topics