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 toSpace announcements l10n. SeeConfiguring-the-Scroll-ViewPort-theme-for-translated-spaces. | |
Usage | Choose one or noneof 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. When should I use a space announcement banner? Use the space organization announcement after you change the content from a book-like organization (such as User Manual, Configuration Manual, and Administration Guide) to the product model. Use the latest version announcement to push traffic to later versions. You do not need to add this to every previous version, but if you have a specific reason that you want users to be aware—for example, Google searches show content for an obsolete version—use the banner to help users find a relevant version. When an announcement is no longer needed, remove the BMC Space Banner macro. | |
Space announcementThis documentation space provides the same content as before, but the organization of the content has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.
PASTE is only valid in Edit table mode. Use the PASTE command to copy the contents of the current paste buffer, or clipboard, into the current table or into a dataset (PASTE DS). When pasting into the current table mark the destination row with the A (after current row), or B (before current row) line command (see also A-After andB-Before). When you press Enter, thePaste Column Selection Windowdisplays so you can verify column matching.
The paste buffer keeps its content until the next CUT REPLACE command overwrites the current content (seeCUT-CU). File-AID for Db2 keeps the paste buffer active for the entire File-AID for Db2 session.
DS
Saves the contents of the paste buffer to a data set, in delimited format.
Paste Dataset
The Paste Dataset screen displays when you enter the PASTE DS command. Use it to specify the output dataset.
File-AID for Db2 prefills the dataset name with a fully-qualified dataset name constructed from the user ID and the current object name. The dataset name may be modified, if necessary. The following figure shows a sample screen.
PASTE Dataset screen
Paste Dataset Format is Delimited
Change Delimited Options
Specify whether you want to change the current delimited file format options or not. EnterYesto view and change the current options (seeDelimited Format Options). EnterNoif you do not want to view or change the current delimited format options.
Specify Output Datasets Area
PASTE Dataset
The name of the data set which contains the pasted data. The second level qualifier is an asterisk (*) that is replaced with the table name specified below. The data set may be either sequential, partitioned, new or existing. If the data set exists, its LRECLmustbe greater than or equal to the calculated record length of the output data record. If its LRECLis less than the required minimum or its DSORG is invalid, a warning window (Extract Warning Window) displays, asking you whether you wish to DELETE and Reallocate the data set or NOT.
If the data set is new, Extract Dataset Allocation Screen displays. It may be allocated as either sequential or partitioned. The default is to create the data set as sequential
Member
If the file is a partitioned dataset, enter an existing or new member name. Enter an asterisk (*) to select a member from a member list.
Table Name
The table name that replaces the asterisk (*) in the above dataset name.
Once you specify the dataset name File-AID for Db2 continues either withDelimited Format Options, orExtract Dataset Allocation to save the contents of the paste buffer in the specified data set.
Paste Column Selection Window
Before File-AID for Db2 executes the PASTE command it allows you to select the columns you want to paste into your current table. When column names of the paste buffer and destination table do not match, you can manually select and match them with the Paste Column Selection Window. The Paste Column Selection Window (see the following figure) prompts you for the information required to complete the paste operation.
PASTE Column Selection window
Selecting Columns
Similar to Building Column Relationships (compareBuilding Column Relationships), you match column names in the Paste Column Selection window.
The fields in the lower portion of the Column Selection screen comprise two lists. These lists contain names, data types, and lengths of columns from the Cut From and Paste To tables specified in the upper portion of the screen. Use these lists to select and match column names.
Follow this procedure to select and match column names:
- Review the prefilled information. In this example, 3 is prefilled in the CMD field for Paste To column EMPNO, same column name, type, and length. If it matches what you want, go to step 5.
- Decide which Cut From and Paste To columns you want to select.
Enter the number from the column NUMber field that corresponds to the Cut From column into the CMD column next to the name of the Paste To column.
Corresponding Cut From and Paste To columns must have the same data type, length, and nullability. Otherwise, File-AID for Db2 displays an error message and does not perform the paste.
For example: You want to paste the data of the DEPTNO column from the DEPT table to the WORKDEPT column of the paste to table EMP (seePASTE Column Selection window). Since the DEPTNO column number is 1, enter a 1 in the CMD field next to the WORKDEPT column of the Paste To table. Both of these columns have the same column type and length: CHAR(3).
- Enter the matching numbers for all remaining columns you want to select for the paste operation.
- Enter END to submit the column selections.
The paste operation concludes by filling all matched columns.
