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.

Extract file specification

The Extract File Specification screen shown in the following figure is displayed when you select Option 7 - Extract File from Extract Menu.

Extract File Specification Screen

File-AID/RDX ------------- Extract File Specification -------------------------
Command ===>

Specify Extract "TO" File Information:
   File name    ===> FRSAMP.EXTRACT.NEW
   Member       ===>          (Blank or pattern for member list)
   VOLSER       ===>
   Disposition ===>          (NEW, OLD, SHR)

Extract File Format:
   Compress     ===> N   (N = No; V = VARCHAR; C = Compress)
   DB2 Format   ===> 1   (1 = Unicode; 2 = Convert Unicode)

Capture create DDL during extract for:
   Views ===> N   Alias ===> N   Synonyms ===> N    ( Y = Yes; N = No)

Selective Column ===> Y      (Y = Selective Column / Delimited Extract,
                               N = Standard Extract)

Use this screen to specify information about the file to which File-AID/RDX will copy extracted data.

Specify Extract “TO” File Information

File Name

Specify the name of the file to which data will be extracted. For more information on the extract file, see Extract File and File-AID/RDX Extract File.

Important

File-AID/RDX will dynamically reallocate a sequential extract file to adjust to the needed space. Dynamic reallocation is only available for sequential files (DSORG=PS).
File-AID/RDX supports extracting from and loading to Sequential (PS) files greater than 65,535 tracks (DSNTYPE=LARGE) when the MVS Operating System also supports them. Allocation of a data sets with DSNTYPE=LARGE is not supported. If the Extract File is to be defined as DSNTYPE=LARGE, it can be pre-allocated.
When the specified extract output is to tape or cartridge, File-AID/RDX automatically creates a summary file on DASD. The name of the summary file is the one specified in your profile or, if none is specified there, it is the name of the extract file with SUMMARY appended or a truncated form of the extract file name with SUMMARY as to not exceed 44 characters. If the summary file exists, File-AID/RDX will update (overwrite) its content. For more information, see Extract Summary File.

Member

If the file you specified in File Name is partitioned, you can enter a member name. If you leave this field blank or specify a pattern, File-AID/RDX displays a Member List pop-up window containing a list of members that match the specified pattern. The only valid pattern character is an asterisk (*). You can create new members by entering the name of the new member in the Member field.

VOLSER

If the file specified in File Name is non-cataloged or new, specify the volume serial number of the file. For non-cataloged files, a volume serial number is required. For new files, a volume serial number is optional.

Disposition

Specify the disposition of the extract "to" file. You can extract to existing files with a disposition of OLD. Existing files must conform to the format outlined for the extract file in File-AID/RDX Extract File. Specify a disposition of NEW to create a new sequential file.

If you specify NEW in the Disposition field, you must specify the following allocation parameters in the Create New File screen.

Extract File Format

Compress

Specify one of the compress options for the extracted data in the extract file:

N	File-AID/RDX won’t compress the extracted data. Recommended when extract file is also to be used outside of File-AID/RDX.
V	VARCHAR compression only affects VARCHAR, LONGVAR, VARGRAPHIC, and LONGVARGRAPHIC columns of Db2 objects; it will not apply to MVS objects. The VARCHAR compression option only writes the actual data within each VARCHAR column without padding the records with trailing blanks; the length of a VARCHAR column will vary for each row based on the data within the row. VARCHAR data written to the Extract file using VARCHAR compression will be readable since only the trailing blanks will be dropped. File-AID/RDX recognizes these compressed extract files as valid input files for all functions: Load, Delete, and Disguise.
C	Compress; The extracted data will be compressed to reduce the file size and preserve disk space. The entire data record is compressed. This technique provides the greatest amount of data compression. File-AID/RDX recognizes these compressed extract files as valid input files for all functions: Load, Delete, and Disguise.

Important

If you intend to use a compressed extract file outside of File-AID/RDX, for example to load the extract file via BMC Compuware File-AID/EX or manipulate it with BMC Compuware File-AID/Data Solutions, you must decompress it beforehand. Use the Decompress utility provided with the Extract File Compress Utility to decompress a compressed extract file.

DB2 Format

Specify whether data extracted from Db2 tables with Unicode encoding is written to the extract file in Unicode or EBCDIC format (see also profile value Db2 Format).

1	Unicode option will write the data using Unicode encoding.
2	Compatibility format will maintain the EBCDIC encoding used in previous releases.

Capture create DDL during extract for

File-AID/RDX always captures the DDL for the tables it extracts related data from as well as the corresponding indexes, tablespaces, and databases. Capturing the DDL for these additional objects (views, alias, and synonyms) will require additional Db2 resources and may increase the total extract time.

Views

Specify whether the extract file should include all the Db2 DDL Create View statements necessary for File-AID/RDX to also create the Db2 views when performing a load using this extract file. Note that DDL statements for creating views from a view will not be included.

Yes	Extracts all Db2 Create View DDL statements for the Db2 tables from which data is being extracted.
No	File-AID/RDX won’t include Db2 DDL Create View statements in this extract file.

Alias

Specify whether the extract file should include all the Db2 DDL Create Alias statements necessary for File-AID/RDX to also create Aliases when performing a load using this extract file.

Yes	Extracts all Db2 Create Alias DDL statements for the Db2 objects from which data is being extracted.
No	File-AID/RDX won’t include Db2 DDL Create Alias statements in this extract file.

Synonyms

Specify whether the extract file should include all the Db2 DDL Create Synonym statements necessary for File-AID/RDX to also create synonyms when performing a load using this extract file.

Yes	Extracts all Db2 Create Synonym DDL statements for the Db2 objects from which data is being extracted.
No	File-AID/RDX won’t include Db2 DDL Create Synonym statements in this extract file.

Selective Column / Delimited Prompt

When File-AID/RDX determines that you have chosen a single table extract, the extract is eligible for Selective Column extract and output of the extract file as delimited or standard.

Only single table Db2 extracts are eligible for a Selective Column extract or delimited extract file.

Selective Column

Enter Y to enable Selective Column extract and/or output of the extract file as delimited. When you press Enter, the Delimited Format Options Screen displays to continue the dialog.

Selective Column Extract

Selective Column Extract allows you to specify the columns of an Object you want to extract. You can indicate the order of the selected columns and in addition, you can indicate the order that you would like to see the rows extracted. Selection criteria can also be entered for each column. A standard extract data set is created which can be used to load data.

Delimited Extract

Delimited Extract creates an extract data set which may be loadable into other RDBMS or spreadsheets that accept delimited file format. Selective Columns are allowed with the Delimited format. A Delimited Extract file is not loadable in File-AID/RDX.

Enter N to continue with a standard extract without Selective Column or Delimited Extract options.

Primary Commands

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

END

Returns to the Extract Menu. There are no operands associated with this command.