Step 9—Specifying related disguise criteria

Option

Type 4 to select the Translator disguise function.

Description

Type RELATED UNIQUE TRANSL. CUST_NUM:FRSAMP.ORDER_TABLE to identify that this related disguise rule uses the unique translate function.

Press Enter

G - GLOBAL

Displays the “Define Global Fields Screen” which 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 Menu” screen. 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 Menu” screen. 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 Dataset). 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 Menu” screen. 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. 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.

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.

6 - FIELD EXITS

7 - DATA ENCRYPTION

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. .

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
Displays the number of sets of criteria that are specified. A set of selection 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.

Disguise Object

Identifies the name of the object you selected in the “Data Disguise - Object List”.

Column

Identifies the name of the column/field of the object you selected in the Data Disguise - Column/Field List. For a related rule, you can replace the value of the related column/field, but you may search/select on other fields.

Related rule

Description

Displays the disguise rule description as entered during the disguise creation. By default, it includes the word RELATED for related mode, followed by the related column/field and object name.

CANCEL

END

MENU

SAVE

VIEW

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

TABLE DATASET

Type FRSAMP.TRANSLAT(SSANDCC) to point to the sample translate table for customer, social security, and credit card numbers.

RO

Type UR as the relational operator for column CUST_NUM.

Press Enter

ALIGN (AL)

Controls display of ALIGNED/UNALIGNED term for PL/I data.

ARRAY (AR)

Controls display of array declaration information for PL/I data.

BACK

Positions the display to the previous criteria. Synonym for LEFT.

CANCEL (CAN)

Returns to Criteria Menu without saving current updates.

CHANGE 
(CHG or C)

Switch from the Selection Criteria to the Change Criteria panels. This command is only valid on the Record Layout Selection Criteria and Global Selection Criteria panels.

COMPLEX (CM)

Controls display of COMPLEX terms for PL/I data.

DELETE (DEL)

Deletes a criteria set (change and associated selection criteria).

DISPLAY (DIS)

Specifies a display format.

DOWN

Scrolls down.

END

Ends display of the formatted criteria screen and displays the Criteria Menu.

FILLER (FILL)

Controls display of FILLER fields.

FORWARD (FWD)

Positions the display to the next criteria. Synonym for RIGHT.

GLOBAL (GBL)

Displays the GLOBAL Change Criteria panel which shows the defined global fields (variables). Use this panel to create criteria which will test values of global fields. Valid only if a global field has been defined.

On the GLOBAL Change Criteria panel, you enter change criteria in the same way you enter change criteria on the record layout; the normal relational operators are available to operate against the global variables.

GROUP (G)

Controls the display of occurrences of group-level items.

IMPORT

Import an existing layout.

INPUT/ INSERT (I)

Inputs/inserts a new criteria set.

LEFT

Positions the display to the previous criteria. Synonym for BACK.

LOCATE (L)

Scrolls directly to the specified record layout line.

LR (Locate Record)

Positions the display to the specified criteria number.

MESSAGE (MSG)

Controls the message display.

OCCURS (OCC)

Controls the display of array declaration items.

OFFSET (OFST)

Displays field offsets.

PICTURE (PIC)

Controls the display of the PICTURE or DISPLAY line for numeric data.

PROFILE (PROF)

Displays profile information lines.

RECORD (REC)

Closes the Global Change or Global Selection Criteria panel and returns to the Formatted Selection or Change Criteria panel. Only valid on the Global Selection Criteria or Global Change Criteria panels.

REDEFINE (RED)

Controls the display of data item redefinitions.

REFLNG (REF)

Controls the display of BIT/CHAR REFER field length reference lines for PL/I data.

REPEAT (R)

Causes a criteria set (formatted change and selection) to be repeated.

RESET (RES)

Causes excluded lines to be redisplayed.

RETURN

RIGHT

Positions the display to the next criteria. Synonym for FORWARD.

SELECT (SEL)

Displays the Formatted Selection Criteria screen.

SHOW (S)

Displays LEVEL, NUMBER, FORMAT, OFFSET, or PICTURE information for the selection fields.

SYNC

Controls the display of the SYNC term for fields in a COBOL record layout.

UP

Scrolls up.

VIEW (V)

Displays the View Criteria screen which is a keyword summary of the current settings for formatted change and selection criteria.

ZERO (Z)

Controls the display of leading zeros in the numeric data fields.

Order

Type 1.

Location

Type 1.

Table name

Type FRSAMP.CUSTNUM.UNIQTAB for the unique value table.

Retain table

Type Y to retain the unique value table.

CMD

Type END.

Press Enter

Field Name

Name of selected field as defined by the record layout.

Data Type

Data type of selected field as defined by the record layout.

Length

Order

The order in which multiple fields are to be concatenated before being used to locate the translate table entry. Must be 1-9 and sequential beginning with 1.

Location

Location of the replacement data in the translate table.

Data Type

Type of data at the specified location in the translate dataset. Valid entries are: CHAR (Character), VCHR (Variable length Character), NUM (Numeric), BIN (Binary), HEX (Hexadecimal), PS (Packed Signed), DBCS (Double Byte Character Set) or VDBC (Variable length Double Byte Character Set). This data type does not have to match the field's data type as defined by the record layout. If the two data types are different, Data Solutions converts the replacement data type to the data type specified in the record layout.

Length

Length of data in translate table. If this length is greater than the length defined in the record layout, then truncation occurs.

Table Name

The Unique Value table (UVT) tracks the association between the input values and the translate table entry used for the replacement values. Specify the name for the Unique Value table.

If Retain Table value (see below) is N(No) a name can be assigned when multiple sets are to share the same translate and Unique value tables (UVT). Each set refers to the UVT by the same name.

If Retain Value is Y(Yes) this field must have a valid dataset name. If the dataset does not exist it will be allocated during the processing. This file is in a masked format.

Retain Table

CANCEL (CAN)

Discards the entries and returns to the formatted Translator Criteria screen.

END

Saves the entered parameters and returns to the formatted Translator Criteria screen.

Command

Type END.

Press Enter

Option

Type END.

Press Enter

Line Command

Type I.

Command

Type END.

Press Enter

EXPAND

Type the EXPAND command then position the cursor on the scrollable field before you hit Enter. That displays the entire field contents.