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. |
File-AID for DB2
The verification steps for File-AID for Db2 use Db2 sample tables which are built with Task 11.2 Create Db2 Training Files (XVJTRNDB).
Task 13.20 Verify Primary Options
- Invoke through the method chosen during customization of your environment.
- From the File-AID for Db2 Primary Option Menu, verify that you can invoke each of the primary options by entering the appropriate number or letter and pressing Enter.
- As you confirm that you can invoke an option, invoke the next one by either returning to the Primary Option Menu using the END command or pressing PF3 and then selecting the next option or by going directly to the option using a jump command (for example, =3 to go to option 3, Utilities).
Task 13.21 Verify XFDCOPY CLIST
The XFDCOPY CLIST must be available to you in order to continue the verification process (see Installing-Training-Files).
- Type TSO %XFDCOPY on the COMMAND line to execute the XFDCOPY CLIST.
File-AID displays progress messages as the sample files are created. - Answer the question OK TO DELETE? with Y (Yes) to delete existing FDSAMP.RELATION and SHOW.SQL files, then create new copies.
Task 13.22 Verify Option 2, Edit
Invoke option 2, Edit.
Edit Options screen, shown in the following figure, is displayed.
Edit Options
- Fill in the screen information as shown other than the following fields:
- In the SSID field, specify the subsystem ID that was used when creating the sample tables (Task 11.2 Create Db2 Training Files (XVJTRNDB)).
- In the Creator field, specify the creator name for ORDER_TABLE that was used when creating the sample tables.
- In the Table Name field, specify ORDER_1.
- In the Relationship File field, specify the Relationship file name you built using XFDCOPY (Task 13.21).
Press Enter.
The File-AID for Db2 Edit screen (Table mode), shown in the following figure, displays in Table Mode.
Edit Table Mode
- Issue REDIT primary command on the screen, to invoke Related Edit function.
Press Enter.
File-AID for Db2 displays the Related Table List window, shown in the following figure.
Related Table List
- Enter S line command in front of the ORDER_LINE_1 entry.
Press Enter.
File-AID for Db2 displays the Related Table screen as shown in the following figure.
Related Table Edit Screen
The screen has one row of ORDER_1 in the half top of the screen as the parent table row, and the corresponding rows in the related table ORDER_LINE_1 in the half bottom of the screen as the dependent table rows.
The related keys between these tables are ORDER_NUMBER in ORDER_1 and ORDER_NUM in ORDER_LINE_1.
- With the cursor in the bottom half of the screen, press PF3 (END) to return to the original Edit screen.
Enter the ROW primary command.
File-AID for Db2 displays the Edit screen (Row mode) as shown in the following figure.
Edit Row Mode
- Press PF4 (RETURN) to return to the File-AID for Db2 Primary Option Menu.
Task 13.23 Verify Option 3.4, Object List Utility
Invoke option 3.4 Object List Utility.
File-AID for Db2 displays the Object List Utility screen as shown in the following figure.
Object List Utility
- Fill in the following information:
- In the SSID field, verify that the subsystem ID that was used when creating the sample tables (Task 11.2 Create Db2 Training Files (XVJTRNDB)) is prefilled.
- In the Object Name field, specify * (asterisk).
- Type S in front of Table to select Table object.
- In the Object Creator field, enter the Creator name that was used when creating the sample tables.
Press Enter.
File-AID for Db2 displays the Object List Selection screen as shown in the following figure.
Object List Selection
- Type GD line command for the ORDER_1 to view the DDL for the table.
Press Enter.
File-AID for Db2 displays the Getting Started with the Object Administration Utility window (see the following figure). (The window is not displayed, if you set to not display the window in option 0.5.)
Getting Started with the Object Administration Utility
- Scroll down (PF8) to read the remainder of the short tutorial.
Press Enter to go forward.
File-AID for Db2 Object Administration generates DDL for the table and displays it (see the following figure).
DDL for ORDER_TABLE
- Press PF4 (RETURN) twice to return to the File-AID for Db2 Primary Option Menu.
Task 13.24 Verify Option 5.1 (Print Table Data)
Invoke option 5.1, Print Table Data.
File-AID for Db2 displays the Print Options screen as shown in the following figure.
Print Options
- Fill in the following information as shown other than the following fields:
- In the SSID field, verify that the subsystem ID that was used when creating the sample tables (Task 11.2 Create Db2 Training Files (XVJTRNDB)) is prefilled.
- In the Creator field, enter the Creator name that was used when creating the sample tables.
- In the Table Name field, enter CUSTOMER_1.
Press Enter.
File-AID for Db2 displays the Table Print Output Specification screen as shown in the following figure.
Table Print Output Specification
- Type S line command in front of TO PRINTER to select output to printer.
- Enter your site’s printer name in the Printer Destination field.
- Specify your site’s Sysout Class, if necessary.
Press Enter.
File-AID for Db2 generates Print JCL and displays it as shown in the following figure.
Print JCL
- Verify the generated JCL. Use the scroll commands to view all.
- Type SUBMIT in the command line to submit the job.
- Press Enter.
Verify the job output.
Table data is printed in F2SYSOUT DD. See the following figure for a partial listing.
Table Print Report
- Press PF4 (RETURN) to return to the File-AID for Db2 Primary Option Menu.
- Press PF3 (END) to exit File-AID for Db2.
Related topics