This site will undergo a maintenance outage on Saturday, 13 September beginning at 2:30 AM Central/1 PM IST for a platform upgrade. The downtime will be ~three hours.

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.

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 announcement This 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 (PAS)

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 and B-Before). When you press Enter, the Paste Column Selection Window displays so you can verify column matching.

The paste buffer keeps its content until the next CUT REPLACE command overwrites the current content (see CUT-CU). File-AID for Db2 keeps the paste buffer active for the entire File-AID for Db2 session.

image2021-3-9_16-49-19.png

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

image2021-3-9_16-50-7.png

Paste Dataset Format is Delimited

Change Delimited Options

Specify whether you want to change the current delimited file format options or not. Enter Yes to view and change the current options (see Delimited Format Options). Enter No if 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 LRECL must be greater than or equal to the calculated record length of the output data record. If its LRECL is 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 with Delimited Format Options, or Extract 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

image2021-3-9_16-51-25.png

Selecting Columns

Similar to Building Column Relationships (compare Building 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:

  1. 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.
  2. Decide which Cut From and Paste To columns you want to select.

  3. 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 (see PASTE 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).

  4. Enter the matching numbers for all remaining columns you want to select for the paste operation.
  5. Enter END to submit the column selections.

The paste operation concludes by filling all matched columns.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*