Step 5—Specifying disguise criteria

Type 4 to select the Translator disguise function.

This field is automatically prefilled with a description composed of the word UNRELATED plus the name of the data item being disguised. You may overtype the description field with more meaningful text if you wish.

Press Enter

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.

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. An object of an ODO/REFER is non-selectable.

6 - FIELD EXITS

Displays the “File-AID/Data Solutions Field Exit Criteria Menu” screen. Formatted field exit criteria enable 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

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

Disguise Object

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

Column

Identifies the name of the column/field of the object you selected from the Data Disguise - Column/Field List.

Unrelated rule

Description

Displays the disguise rule description as entered during disguise creation. By default, it includes the word UNRELATED for unrelated mode, followed by the related column/field and object name. You can change this text at the time of creation if you want.

CANCEL

END

MENU

SAVE

VIEW

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

Type TSOID01.TRANSLAT(SSANDCC) to point to the sample translate table for customers.

Type UR as the relational operator for column CUSTOMER-NUMBER.

Press Enter (or PF3)

Table dataset

Specify the data set that contains the translation data information (translate table). If it is a member of a PDS, type the “data set (membername)” combination.

Set

Identifies the set of criteria displayed.

01 Level Name

Name of the record file structure from layout.

GBL

Specifies whether one or more global fields have been attached to this set of criteria (N or Y).

SEL

Displays whether selection criteria has been attached to this set of criteria (NO or YES).

FIELD LEVEL/NAME

Name of the field from layout.

FORMAT

Length and type of field.

RO

Specify a relational operator. Possible values are:

S

Binary search field

K

Key search field

D

Direct row pointer search field

H

Hash to a key search field

U

Unique search field

R

Result field

SR

Binary search and result field

KR

Key search and result field

DR

Direct row pointer search and result field

HR

Hash to a key search and result field

UR

Unique search and result field

FM

Field mask. See “Field Mask” of the File-AID/Data Solutions Reference manual for more information.

EP

Edit parameters.

Parameters

Displays search and/or result parameters for each field.

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.

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.

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.

Type 1.

Type 1.

Type 'TSOID01.uvt.translat(ssandcc)'.

Type 'TSOID01.custnum.uniqtabl'. Whatever you enter for Table Name here should be a valid data set name (when Y is specified for Retain Table below). If the data set does not exist, it will be created during later processing. This data set is called the Unique Value Table, or UVT.

Type Y to retain the unique value table.

Press PF3 after you have filled in the above information to add the disguise rule.

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 data set. 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 data set name. If the data set does not exist it will be allocated during the processing. This file is in amasked 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.

Type END (or press PF3).

Press Enter

Type END (or press PF3) to exit.

Press Enter

Type I to display information.

Press Enter

Type END (or PF3).

Press Enter

Rule

Identifies the disguise rule assigned to the selected column/field.

Unnnnnnn identifies an unrelated rule

Disguise Criteria File

Object Name

Identifies the name of the object. The rule listed in the Rule field above applies to each of the listed objects. This field is scrollable. Use the LEFT, RIGHT or EXPAND scrolling commands to view the remaining parts of a name.

Unrelated Column/Field Name

Identifies the name of the column/field for each object.

EXPAND

Position the cursor on the scrollable data field and press PF13 to display the entire field contents in a popup display. The PF13 key equates to the EXPAND primary command. So another way of doing this is to type EXPAND in the primary command field and then position the cursor to the scrollable data field before pressing ENTER.

Right

Position the cursor on the scrollable data field and press PF11 to scroll the data in the field to the right. The F11 key equates to the RIGHT primary command. So another way of doing this is to type RIGHT in the primary command field and then position the cursor to the scrollable data field before pressing ENTER.

Left

To return to a previous position after scrolling a field to the right, position the cursor on the scrollable data field and press PF10 to scroll the data in the field to the left. The F10 key equates to the LEFT primary command. So another way of doing this is to type LEFT in the primary command field and then position the cursor to the scrollable data field before pressing ENTER.

Type END (or PF3).

Press Enter