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.

File-AID/Data Solutions Criteria Menu

The File-AID/Data Solutions Criteria Menu is the entry and exit panel into File-AID/Data Solutions after File-AID for Db2 transfers the control so you can specify the disguise criteria for the selected object column/field. The File-AID/Data Solutions Criteria Menu looks slightly different depending on whether related, associated, or unrelated mode is in effect. The menu is specifically designed to accommodate disguise criteria creation or modification for File-AID for Db2 extract objects. This menu cannot be accessed from the stand-alone File-AID/Data Solutions product, only via the bridge from File-AID for Db2.

Regardless of the mode, the presented disguise criteria options are a subset of all available File-AID/Data Solutions functions that are most likely to be used to disguise data for related extracts. You can use the MENU primary command to view to all available options of the File-AID/Data Solutions Criteria Menu.

As File-AID for Db2 provides all the layout information and disguise criteria file and member names, all you need to do is specify the disguise criteria for the selected object.

The disguise criteria is stored in the disguise criteria file. The Disguise Control File keeps track of where the disguise criteria is stored.

Consult your File-AID/Data Solutions User Reference Manual on how to specify the disguise information.

The following figure shows the File-AID/Data Solutions Criteria Menu.

File-AID/Data Solutions Criteria Menu

After you complete defining all the disguise criteria for the selected object column/field, press END to return to the File-AID for Db2 Data-Disguise-Column-Field-List.

Criteria Menu Options

Enter the option number (1, 4, 5, 6, or 7) to select the desired option. The status column to the right of each option identifies the number of criteria sets the have been defined for the current criteria rule with each criteria option.

G - GLOBAL

Displays the Define Global Fields Screen, and enables you to view, define and change user global fields (user variables). It lists all existing user variables in the entered order and displays blank lines for definition of additional user variables. Global fields must start with & (ampersand) and they are retained in the order entered.

1 - DATA AGING

Displays the File-AID/Data Solutions Aging Criteria screen (see File-AID/Data Solutions Aging Criteria). Aging criteria enables you to age dates in data records displayed with a record layout. To specify an aging criterion, choose a date field and enter a relational operator of +, -, R, or FM a numeric value in the century, year, month, and/or days field, and the appropriate date pattern. Leave the relational operator blank for fields not involved in the aging criteria. Use = in the RO field to replicate the last entered criteria.

4 - TRANSLATOR

Displays the File-AID-Data-Solutions-Data-Translator-Criteria screen (see File-AID/Data Solutions Data Translator Criteria). The Data Translator feature translates data values in one or more fields based on a translate table containing lookup and/or result values. The Translator function accesses the translate table based on values from the fields specified on the formatted panel in five different ways:

- Binary search (S): Sorts the values internally and performs a binary search thereby speeding up processing.
- Key search (K): Your search field matches the key field when your table file is a KSDS (Keyed Sequential Data set). If the entire table fits into memory, the key search functions identical to the Binary Search. If there is insufficient memory the table is directly accessed by key.
- Direct row pointer search (D): The search field is hashed to a random number between 1 and the number of rows in the table. The resulting number determines the row to be used. No value in the table matches the original search field.
- Hash to a key search (H): Similar in function to the Direct Row Pointer Key search except that the random number is used to perform the Key search. The search field is hashed to a random number between 1 and the number of rows in the table. For the Hash function to work, the key of the VSAM file must be numeric with leading zeros, start with 1, and increment by 1 for each row.
- Unique key search (U): Each different input value will return a different entry number which will then be used to access the replacement values from the translate table. This will produce unique replacement values as long as the translate table contains unique replacement values.

When the corresponding row is determined, the Translator function returns the result values and uses them to replace the specified output field value.

5.1 - GENERATOR

Displays the File-AID/Data Solutions Data Generator Criteria screen (see File-AID/Data Solutions Data Generator Criteria). The Data Generator feature is used to fill fields with new data values. You may use the Data Generator to fill new fields with test data, or to replace live data that may be sensitive production information that should not be used in test. Data can be generated for numeric and character fields by using one of four methods: sequential, random, pattern masking, or by picking valid values from another file. An object of an ODO/REFER is non-selectable.

The Data Generation function can also be used to generate new records into a new file without specifying an input file from which to model the records. A Layout containing an ODO/REFER CANNOT be used.

5.2 - PATTERN

Displays the File-AID/Data Solutions Pattern Data Generator Criteria screen (see File-AID/Data Solutions Pattern Data Generator Criteria). The Data Pattern Generator feature is used to fill fields with new data values. You may use the Data Pattern generator to fill new fields with test data, or to replace live data that may be sensitive production information that should not be used in test. Data can be generated for unsigned numeric and character fields by using one of two methods: sequential & random.

6 - FIELD EXITS

Displays the File-AID/Data Solutions Field Exit Criteria screen (see File-AID-Data-Solutions-Field-Exit-Criteria). Formatted field exit criteria enables you to define and process both Data Solutions-defined and user-defined business function data conversions. Field exits distributed with Data Solutions perform the following business functions: Addition, Data Analysis, Date Analysis, Division, European currency conversion, Encryption/decryption, Field Replacement, Hash Value, Move Field, Multiplication, Test date generator, Resequencing, Subtraction, and Use global area.

To specify a formatted field exit criterion, choose a data field and enter the EX relational operator, valid parameters for the exit in the PARAMETERS field, and the name of the exit in the EXIT NAME field. If you enter EP in the RO field, Data Solutions displays the Field Exit Parameters screen. If you leave the EXIT NAME field blank, Data Solutions displays the List of Available Field Exits screen. Leave the relational operator blank for fields not involved in the aging criteria.

Use the INPUT, INSERT, or REPEAT primary command to specify multiple sets of change criteria. When multiple sets are specified, Data Solutions applies them separately in the order specified.

In addition, you can make the change process contingent on the field values in the record through the use of selection criteria. Simply enter the SELECT primary command on the Formatted Field Exit Criteria screen to display the Formatted Selection Criteria screen.

7 - DATA ENCRYPTION

Displays the File-AID/Data Solutions Data Encryption Criteria screen (see File-AID-Data-Solutions-Data-Encryption-Criteria). The Data Encryption function simplifies the process of encrypting and decrypting a data file. It transforms a field value to mask the original value and is useful when creating test files from production files.

File-AID/Data Solutions uses encryption/decryption exits to define and process both Data Solutions-defined and user-defined encryption routines. Simply choose a routine for a particular field from Data Solution's list of Available Encryption/Decryption Exits. With the use of selection criteria, you can assign an encryption routine to a field based on the data in that field or on the data in another field in the record.

The original data characteristics are maintained (i.e. valid packed fields or punctuation in character fields). In addition, unique values are maintained so that the key field remains unique. This permits you to decrypt the encrypted data to its original value.

The Key Encrypt/Decrypt Exit is a Data Solutions-defined exit. Two sample encryption/decryption routines are also available. You can use one of the sample encryption/decryption routines or create your own routine.

8 - REPLACE

Displays the File-AID/Data Solutions Data Replace Criteria screen. It allows you to specify a replace value (R) or source (FF for field-to-field) for the specified field.

The status column to the right of each option identifies the number of criteria sets the have been defined for the current criteria rule with each criteria option.

Status

Displays the status of the various types of criteria associated with the criteria data set listed on the top line of this screen and the disguise rule for the current disguise object:

n fields

Specifies the number of global variable fields that have been defined. These user defined variables are available for use by any of the sets within the criteria.

n sets

Specifies the number of sets that are specified for change criteria. A set of change criteria is defined as a single expression that can lead to the selection of a record. A set may test for one condition or several conditions. The conditions can be ANDed together and several conditions separated by commas create nested OR conditions within a set.

Primary Commands

The following primary commands are valid:

CANCEL (CAN)

Returns to the File-AID for Db2 Data-Disguise-Column-Field-List without saving any criteria information.

END

Saves the current change criteria in the criteria data set you specified in the File-AID/Data Solutions Parameters and returns to the File-AID for Db2 Data-Disguise-Column-Field-List.

2.1 - EURO CONVERSION

Displays the File-AID/Data Solutions Euro Conversion Criteria screen (see File-AID/Data Solutions Euro Conversion Criteria). The European Currency Conversion Criteria screen enables you to enter currency conversion criteria to convert the specified field to or from the EURO (or ECU (European Currency Unit)). You must specify the data set name of an existing European currency rate file (i.e. DASAMP.FACTORS).

2.2 - TRIANGULATION

Displays the File-AID/Data Solutions Triangulation Criteria screen (see File-AID/Data Solutions Triangulation Criteria). Euro Triangulation enables you to convert from one local currency into another using Euro values to triangulate and control the conversion in accordance with ECU guidelines. An audit report can be generated to document the changes, including the intermediate Euro values.

3.1 - DATE PATTERN ANALYSIS

Displays the File-AID/Data Solutions Date Analysis Criteria screen (see File-AID/Data Solutions Date Analysis Criteria). The Date Analysis feature simplifies the identification of date fields. It is functionally the same as the Date Analysis field exit.

By automatically comparing date values to a list of date patterns, File-AID/Data Solutions produces a report that lists the percentage of times a valid date is present and the number of times each date format is valid. You can compare your files to the date patterns provided or to those you've specifically created. The report can be viewed online or in batch mode.

3.2 - VALIDATION

Displays the File-AID/Data Solutions Validation Criteria screen (see File-AID/Data Solutions Validation Criteria). Validation Analysis enables you to validate data based on data type or the actual values within the record. You may specify the "valid" values for a field online or in an external file. Validation processes include alpha, alphanumeric, and numeric data checking.

When invalid data is found in any of the fields of a record, a user-specified return code is set indicating the validation process failed.

3.3 - DATA ANALYSIS

Displays the File-AID/Data Solutions Data Analysis Criteria screen (see File-AID/Data Solutions Data Analysis Criteria). The Data Analysis function analyzes the data in a particular field by comparing the data to its record layout field definition and reports whether the data is valid or invalid. The report includes whether invalid data was found in the specified field, the range of data found in that field, and the number of times each unique value occurs within the field.

You can determine how the values are analyzed. You may supply a list of values for Data Solutions to search for and report only those values found within the field.

RETURN

Saves the current change criteria in the criteria data set you specified in the File-AID-Data-Solutions-Parameters and returns to the File-AID for DB2 Primary Option Menu.

SAVE

Saves the current criteria in the criteria data set you specified in the File-AID/Data Solutions Parameters.

Important

It is highly recommended you use separate criteria files for disguise criteria created through the File-AID for Db2 interface and name them in such a way as to easily recognize them as such. As the layout information for the File-AID for Db2 extract object may be different from the information you would provide with the stand-alone File-AID/Data Solutions, the disguise process may not produce valid and repeatable results.

VIEW

Displays the View Criteria screen, which summarizes the options and criteria sets into a scrollable display.