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.

Table Copy Selection

The Table Copy Selection screen (see the following figure) appears when you select option 3 from the Utility Selection Menu.

Table Copy Selection Screen

image2021-3-10_16-28-3.png

From Table Area

Creator

ID of person who created the table or view to be copied.

Table Name

Name of the table, alias, synonym, or view to be copied. Wildcard characters (see Wildcard-Characters) can be used to display the Copy From Selection window (Copy From List of Tables).

To Table Area

Location

Db2 Subsystem Location ID of the table to which the data in the From Table is being copied to. If you leave the Location field blank, then the To Table Area is assumed to be on same subsystem to which File-AID for Db2 is connected.

Creator

ID of person who created the table or view to which you are copying.

Table Name

Name of the table, synonym, view, or alias to which you are copying. Wild card characters (see Wildcard-Characters) can be used to display the Copy To Selection window (Copy To List of Tables).

If you specify a table that does not exist, the Auto Create window appears (Auto Create Window).

Important

If the source (copy from) table has at least one trigger defined, a message indicating that a trigger exists appears in the Auto Create confirmation screen.


Specify Selection Criteria Information Area

Selection Criteria Usage

Specify whether you want to use a previously saved selection criteria dataset. This allows you to develop your own WHERE clause conditions as criteria for the copy.

Specify the letter that represents the activity you want to perform:

T

Create Temporary selection criteria. The Criteria Display Format field determines the format used for the criteria.

M

View or modify existing saved selection criteria. The criteria contained in the selection criteria dataset is displayed in the format specified by the Criteria Display Format field.

E

Execute existing saved selection criteria. The criteria is not displayed.

N

Do not apply selection criteria. All rows for the object are copied.

Criteria Display Format

Specify whether selection criteria is to be entered on the Template, or as native SQL. This field only applies when the Selection Criteria Usage field is T (Temporary), or M (Modify).

Specify the letter that represents the activity you want to perform:

T

Selection criteria is processed using the Template. If you specified to Modify the Template in the Selection Criteria Usage field, then the SQL will automatically display with a message stating the SQL has been substituted.

S

Selection criteria is processed in Edit using native SQL.

Criteria Dataset Name

If you specify M (Modify) or E (Existing) Selection Criteria Usage, specify an existing sequential or partitioned dataset with RECFM=FB and LRECL=80. File-AID for Db2 prefills this field with the name of the last specified selection criteria dataset.

If you specify T (Temporary) Selection Criteria usage, a temporary data set (hlq.userid.SYSyyddd.Thhmmss.SHOW.SQL) containing the SQL source is created. An ISPF edit session is initiated, enabling you to edit the SQL. If you want to save the SQL source, you must use the ISPF CREATE or COPY command to a permanent data set before exiting the edit session. The temporary data set will be deleted when returning to the Table Copy Selection Screen.

Member

Specify the member of the data set you want to use. The field is prefilled with the last specified member name. If you leave this field blank or specify an asterisk (*), File-AID for Db2 displays the Member List for the data set. Specify a pattern, for example PART*, to narrow down the member list to the matching member names. The asterisk (*) is the only valid pattern character.

Specify Copy Options Area

Maximum Rows To Select

Enter the maximum number of rows to be copied.

Column Selection

Indicate whether you want to select columns to be copied. This option, for example, lets you map columns with like data types but unlike names. Enter Y when you want to copy only selected columns of similar or dissimilar tables/views. Column selection is ignored for the S option.

If you enter Y in this field, the Copy Column Selection screen (Copy Column Selection screen) appears. If you enter N, the Copy Row Selection screen (Copy Row Selection screen) appears.

Delete Existing Rows

Indicate whether you want to clear out all existing rows in the table you are copying to before the new rows are inserted.

Column Name Matching

Indicate whether the columns you are copying will be mapped to target columns with the same names. This option is convenient if you are populating a table or view that is defined the same as the one you are copying from, or if the FROM and TO tables or views have columns with matching names but a different order. Matching is ignored for the S option.

Discard Limit

Maximum number of From Table rows you want discarded before the copy process is halted. Enter zero, or any value up to 9999. A value of zero allows the entire input data set to be discarded if errors occur. If a non-zero value is entered, load processing will continue until the number of errors exceeds the specified value. The default is zero.

Use Uncommitted Read

Allows an application to bypass acquiring the locks that ensure no other user is updating the data being read. Bypassing the locks causes the application to run faster. The field is prefilled with the last specified value (YES or NO) or as specified with the UNCOMMITTED_READ_DEFAULT parameter of the Db2 Environment PARMLIB member. For more information, see UNCOMMITTED_READ_DEFAULT in the Db2 environment.

Warning

If you choose the Use Uncommitted Read option, and the application fails and backs out the updates, then the rows read by the application using uncommitted read could be invalid.

NO

Enter NO if you do not want the application to bypass acquiring the locks which ensure that no other user is updating the data being read.

YES

Enter YES if you want the application to bypass acquiring the locks which ensure that no other user is updating the data being read. If you enter YES, the rows read by the application using uncommitted read could be invalid.

Related topics

Object-Administration-and-Objects-Utilities

 

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