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.

Step 1—Specifying extract information


File-AID/RDX displays the following figure when you select Option 2 from the File-AID/RDX Primary Option Menu and your profile specifies DB2 as the default object type. All input fields on this panel are prefilled with values from your current profile.

Extract - DB2 Driving Object

File-AID/RDX  -----------  Extract - DB2 Driving Object  ----------------------
 OPTION ===> G                                                Scroll ===> CSR
                                                       TSOID01 Profile: FRSAMPQK
 Primary commands: MVS driving object, EDIT JCL, GO to submit job

 Specify table to drive extract process from:
  SSID               ===> DSN
  Location           ===>                      (* or pattern for selection list)
  Creator            ===> FRSAMP               (* or pattern for selection list)
  Table Name         ===> ORDER_TABLE          (* or pattern for selection list)
  
 Specify Extract Options:
  Edit Object Selection Criteria    ===> Y      (Y = Yes; N = No)         *None*
  Maximum Rows to Select            ===> *      (* for all rows)
  Use Uncomitted Read               ===> Y      (Y = Yes; N = No)
  Extract IMPLICITLY HIDDEN columns ===> N      (Y = Yes; N = No)     
  SELECT FROM Temporal Table        ===> N      (Y = Yes; N = No)        *None*
 Specify Extract "TO" File Information:                                        
  File name               ===> FRSAMP.QUICKEXT                            
  Format Unicode Data     ===> 2  (1 = Extract as Unicode; 2 = Convert Unicode)
  Edit Data Privacy Spec  ===> N  (Y = Yes; N = No)                      *None*
 
 Relationship Information:
  File name or pattern  ===> FRSAMP.RELATION

Select the object type of the driving object for the extract:

In this field…

Do the following:

Command

Type G to submit the extract job as soon as you complete specifying the selection criteria for the driving table.

SSID

Type the subsystem ID where the sample tables reside, if different from the SSID specified in your FRSAMPQK profile.

Location

Leave blank.

Creator

Type FRSAMP.

Table Name

Type ORDER_TABLE.

Edit Object Selection Criteria

Type Y, so you can enter selection criteria for the driving object.

Maximum Rows to Select

Type * to retrieve all rows that meet the selection criteria for the driving object.

Use Uncommitted Reads

Type Y to extract data from Db2 objects that include Uncommitted Reads.

Extract IMPLICITLY HIDDEN columns

Leave set to N.

SELECT FROM Temporal Table

Leave set to N.

File name

Type FRSAMP.QUICKEXT, if different from the extract file specified in your FRSAMPQK profile.

Format Unicode data

Type 2 for compatibility mode.

Edit Data Privacy Spec

Type N if the current value is *None*. Type Y if the current value is other than *None* and set the Disguise Extract File value to 3 (No) in the Data Privacy Specification panel.

File name or pattern

Type FRSAMP.RELATION, if different from the relationship file specified in your FRSAMPQK profile.

Press Enter

File-AID/RDX displays the Driving Object Selection Criteria screen, where you specify the selection criteria for the driving object.

Field Names and Descriptions

The following list describes all of the fields on this screen.

FIELD

DESCRIPTION

SSID

Displays the current Db2 subsystem ID as specified in your profile. Type over this field to connect to a new Db2 subsystem. If you leave the Location field blank, the table you specify to drive the extract must exist in the Db2 subsystem displayed here.

Location

Specify the location of the table you want to drive the extract if it resides in a remote Db2 subsystem. The location you enter must be defined in the Db2 system catalog table, SYSIBM.LOCATIONS.

Leave this field blank if the table you want to drive the extract is in the Db2 subsystem in the SSID field.

Important

The “Extract from Image Copy” option is not available when extracting from a remote location.

Creator

Specify the authorization ID of the owner of the table, view, synonym, or alias that you want to drive the extract process. You can enter a pattern in this field. Valid pattern characters are %, _, and * (see Pattern Characters). If you specify a pattern, File-AID/RDX searches the Db2 catalog and displays matches in a Table List pop-up window.

Table Name

Specify the name of the table, view, alias, or synonym that you want to drive the extract process.

You can enter a pattern in this field. Valid pattern characters are %, _, and * (see Pattern Characters). If you specify a pattern, File-AID/RDX searches the Db2 catalog and displays matches in a Table List pop-up window.

Edit Object Selection Criteria

Enter Yes so you can specify selection criteria for the driving table. File-AID/RDX will display the Driving Object Selection Criteria screen when you press Enter. However, if the extract request is a single Db2 table extract with Selective Columns and/or Delimited extract file, the Object Selection Criteria - Selective Columns screen displays.
Enter No to extract all rows from the driving table.

Maximum Rows to Select

Specify the maximum number of rows you want to extract from the driving object. Enter an asterisk (*) to retrieve all rows that meet selection criteria. This value is applied after the selection criteria for the driving object has been applied.

Use Uncommitted Read

Specify whether to extract data from Db2 objects that include Uncommitted Reads or not.

The field is prefilled with the specified UNCOMMITTED_READ_DEFAULT configuration parameter value (Yes or No) of the Db2 Environment PARMLIB member or with the current profile value (Yes or No) if UNCOMMITTED_READ_DEFAULT is set to blank (default, for more information, see UNCOMMITTED_READ_DEFAULT in the Db2 environment).

Extract IMPLICITLY HIDDEN columns

Specify whether File-AID/RDX should extract data from IMPLICITLY HIDDEN columns or not. When this option is chosen, the resulting File-AID/RDX extract file will include the data from IMPLICITLY HIDDEN columns.

SELECT FROM Temporal Table

Enter Yes if you want to specify or modify a time-period and date/timestamps for Temporal Tables or Temporal Views. File-AID/RDX will display the “SELECT FROM Temporal Table” screen when you press Enter. Starting with Db2 Version 11, temporal support allows period specifications and period clauses to be specified for views. The same rules apply for views as do for tables.

Enter No (default) if you don’t want to display the “SELECT FROM Temporal Table” screen.

The status *Defined* displays if a SELECT FROM Temporal Table statement has already been defined, otherwise *None* displays.

If you want to extract data from temporal tables or views without a SELECT FROM Temporal Table statement, make sure *None* displays. To change the status from *Defined* to *None*, enter Yes in the SELECT FROM Temporal Table field, then set the Use System Time and Use Business Time to No in the “SELECT FROM Temporal Table” screen.

Important

  • When the *Defined* status displays and the extract request includes one or more temporal tables or views, File-AID/RDX will include the SELECT FROM Temporal Table statement even if the SELECT FROM Temporal Table field is set to N.
  • The SELECT FROM Temporal Table statement is only generated for each Temporal Table or Temporal View in the extract request.
  • Whenever the selection is based on SYSTEM_TIME, it is possible that some rows come from the base table and some from the history table. The *Defined* status is saved for this extract.
  • The SELECT FROM Temporal Table field will be reset to its default (No, *None*) when you exit the extract - DB2 Driving Object screen.

File name

(Extract file) Specify the name of the file to which data will be extracted. Include the member name (in parentheses) when the file is a PDS.

Format Unicode Data

Specify whether Db2 data extracted from tables with Unicode encoding is written to the extract file in Unicode or EBCDIC format.

1

Unicode option will write the data using Unicode encoding without utilizing IBM z/OS Conversion Services.

2

Compatibility format will maintain the EBCDIC encoding utilizing IBM z/OS Conversion Services used in previous releases of File-AID/RDX (default).

Edit Data Privacy Spec

Specify whether you want to change the current data privacy specifications. When data privacy has been specified, File-AID/RDX will disguise the extracted data as part of the extract batch job according to the disguise criteria defined in the Disguise Control file (DCF) or in the Dynamic Privacy Rules Project (DPR). When you enter Y, File-AID/RDX will display the “Data Privacy Specification” screen so you can change the current setting.

Note: Data Privacy is not allowed with a Delimited Extract.

File name or pattern

(Relationship file) Specify the name of the file that contains the referential integrity and application relationship information you want to use for the extract process.

Note: If you leave this field blank, File-AID/RDX will perform a single table extract. Optionally, a single table extract now allows to extract selected Db2 columns and/or output of the extract file in delimited format.

Primary Commands

The following File-AID/RDX-specific primary command is valid on this screen:

EDIT (E)

Displays the JCL for this extract request. File-AID/RDX shows the Generated JCL panel where you can review and modify the extract JCL.

GO (G)

Submits this extract request. Before issuing the GO command, make sure you have completed all the extract information.

MVS (M)

Switches from this panel to the single panel Extract - MVS Driving Object prefilled with the applicable information from your current profile. See Extract - MVS Driving Object.

 

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