Data generator criteria


The following figure allows you to select fields for data manipulation.

Use relational operators SE (sequence), RA (random), MA (mask), TA (table), or FM (field mask) to enter criteria on each field.

Data Generator Criteria Screen

   Action  Sets  Display  Show  Options  Menu  Help
 -------------------------------------------------------------------------------
 File-AID/Data Solutions ------- Data Generator Criteria    CREATE NEW CRITERIA
 COMMAND ===>                                                  SCROLL ===> PAGE
 TABLE DATASET ===>
 SET  1 OF  1           EMPLOYEE-MASTER-FILE                     GBL = N SEL = N
 ---- FIELD LEVEL/NAME ------- -FORMAT- RO --------- PARAMETERS ---------------+
 ******************************* TOP OF DATA ***********************************
 5 EMP-NUMBER                    5/AN
 5 EMP-LAST-NAME                15/AN
 5 EMP-FIRST-NAME               10/AN
 5 EMP-MID-INIT                  1/AN
 5 FILLER                        2/AN
 5 EMP-TITLE                    30/AN
 5 EMP-PERSONAL-INFO SYNC       23/GRP
   10 EMP-NATL-ID-NUMBER         9/NUM
   10 FILLER                     1/AN
   10 EMP-DATE-OF-BIRTH          6/AN
   10 EMP-DOB-REDEF REDEFINES EMP-DATE-OF-BIRTH
   10 EMP-DOB-REDEF SYNC         6/GRP
     15 EMP-DOB-MM               2/NUM
     15 EMP-DOB-DD               2/NUM
 Valid RO: SE = Sequence, RA = Random, MA = Mask, TA = Table, EP, FM
 Commands: SELect, GBL, View

Field descriptions

Table dataset

Data set containing table data for TA (Table) Relational Operator (RO).

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

Specifies whether selection criteria has been attached to this set of criteria (N or Y).

FIELD LEVEL/NAME

Name of the field from layout.

FORMAT

Length and type of field.

RO

Specify a relational operator. Possible values are:

SE

Sequence

RA

Random

MA

Mask (valid only for character data)

TA

Table

FM

Field mask. For more information, see Field Mask.

EP

Edit parameters.

Parameters

Displays sequence, random, mask, or table parameters for each field.

Primary commands

The following is a list of primary commands and their abbreviations that are valid on the Euro Conversion, Euro Triangulation, Data Analysis, Date Pattern Analysis, Data Translator, Data Generator, Pattern Data, Data Encryption, and Data Replace Criteria screens.

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 main panel 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

Terminates display of the formatted criteria screen and displays the Change 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.

IMPORT

Imports an existing change 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)

Controls format of SHOW OFFSET (Columns, Relative, or Hex).

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

Returns to the Primary Option Menu.

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. See View Specification Keywords Screen.

ZERO (Z)

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

Shortcut Commands

When entering or modifying change criteria you can change the type of criteria you are about to enter by using any of the following primary commands:

AGING

switches to Date Aging.

DATAENCR

switches to Data Encryption.

DATAGEN

switches to Data Generation.

DATANALY

switches to Data Analysis.

DATAPGEN

switches to Pattern Data Generation.

DATAREPL

switches to Data Replace.

DATATRAN

switches to Data Translator.

DATAVALD

switches to Validate Criteria.

DATEANLY

switches to Date Pattern Analysis.

EUROCNV

switches to Euro Conversion.

EUROTRI

switches to Currency Triangulation.

FLDEXITS

switches to Field Exits.

For example: You have selected “7 Encryption” on the criteria menu and you are entering encryption criteria and then you want to switch to data translation.

You could press PF3 to go back to the menu and then select “4 Translator” or you could enter the primary command DATATRAN on the data encryption criteria screen.

If you have already entered criteria for the set that is currently displayed, the primary command process assumes that you want to insert the new type of criteria after the current set.

Selection criteria

The Selection Criteria screen is displayed when you enter the SELECT (SEL) primary command on the Data Generator Criteria screen. See Selection-criteria for a sample of this screen and field descriptions.

Global criteria

The Global Criteria screen is displayed when you enter the GLOBAL (GBL) primary command in any of the Data Solutions Change or Selection Criteria screens. It lists all global variables defined with option G of the Criteria Menu. See Global Criteria for a sample of this screen and field descriptions.

Field mask

The Field Mask Criteria screen is displayed when you enter the Field Mask (FM) relational operator in the relational operator (RO) column on the Data Generator Criteria screen. See Field Mask for a sample of this screen and field descriptions.

Field sequence criteria

The Field Sequence Criteria window, shown in the below figure, is displayed when you use the SE relational operator on a field in the Data Generator Criteria screen. It allows you to enter parameters on how the field information is stored.

Field Sequence Criteria Screen

image2021-9-15_9-40-22.png

Field Descriptions

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. When the data type is Character, and the number of significant digits is less than the total field length, the resulting data will contain blanks.

Length

Length of data in selected field as defined by the record layout. This field may be overtyped to shorten or lengthen the length of data replaced. This is particularly useful when you want to replace all the elements of a group item.

Initial Value:

Specify the starting value to begin generating the data for this field.

Skip Value

(Optional) Specify the increment value that you want Data Solutions to use to generate the next sequential value for this field. The default increment value is 1 (one). When the data type is Character, the only valid skip values are 0 and 1.

Primary Commands

The following primary commands are valid:

END

Saves the entered parameters and returns to the formatted Data Generator Criteria screen.

CANCEL

Discards the entries and returns to the formatted Data Generator Criteria screen.

Field table criteria

The Field Table Criteria window, shown in the following figure, opens when you use the TA relational operator on a field in the Data Generator Criteria screen. It allows you to enter parameters on how the field information should be stored.

Field Table Criteria Screen

image2021-9-15_9-43-27.png

Field Descriptions

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

Length of data in selected field as defined by the record layout. This field may be overtyped to shorten or lengthen the length of data replaced. This is particularly useful when you want to replace all the elements of a group item.

Table Access Mode

Specify the method used to access the table. Valid access modes are:

R

Randomly access entries in the table dataset.

S

Sequentially access the entries in the table dataset beginning with the first record.

Table Entry Location

Location of the replacement data in the data generation table.

Table Entry Data Type

Type of data at the specified location in the table dataset.

Valid entries are:


    • CHAR (Character)
    • VCHR (Variable length Character)
    • NUM (Numeric)
    • BIN (Binary)
    • HEX (Hexadecimal)
    • PS (Packed Signed)
    • DBCS (Double Byte Character Set)
    • 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 table data type to the data type specified in the record layout.

Table Entry Length

Length of data in table dataset. If this length is greater than the length defined in the record layout, then truncation occurs. The default is the input field length.

Primary Commands

The following primary commands are valid:

END

Saves the entered parameters and returns to the formatted Data Generator Criteria screen.

CANCEL

Discards the entries and returns to the formatted Data Generator Criteria screen.

Generate mask criteria

The Enter Generate Mask Criteria window, shown in the following figure, opens when you use the MA relational operator on a field in the Data Generator Criteria screen. It allows you to enter parameters on how the field information should be stored.

Generate Mask Criteria Screen

image2021-9-15_9-47-35.png

Field Descriptions

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

Length of data in selected field as defined by the record layout. This field may be overtyped to shorten or lengthen the length of data replaced. This is particularly useful when you want to replace all the elements of a group item.

Mask

Specify the pattern you want Data Solutions to use to generate data. The following entries are valid:

A

Randomly generate any alphanumeric character in this position.

N

Randomly generate any numeric character in this position.

Other

When you use any other character in the mask, the specified character is used in this position as a replacement character. You cannot use the following characters in the mask: Left and right parentheses, semi-colon, and comma. If you require one of these characters, use the REPLACE field exit (described on here).

Important

Random criteria does not guarantee unique values; the results may contain duplicate values. If unique values are required, use unique translation.

Primary Commands

The following primary commands are valid:

END

Saves the entered parameters and returns to the formatted Data Generator Criteria screen.

CANCEL

Discards the entries and returns to the formatted Data Generator Criteria screen.

 

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