Defining your third criteria set

In the Data Translator Criteria screen you can define multiple sets of translate criteria. You manipulate the sets through the action bar item Sets and its pull-down menu. Refer to Sets Pull-down Menu figure for an example of the Sets pull-down menu. See Sets Pull-down Menu for an example of the Sets pull-down menu.

1. Tab to the Sets action bar item and press <Enter>.
2. In the Sets pull-down type 2 and press <Enter> to insert a new criteria set.
3. Press <PF7> to scroll to the top of data.

File-AID/Data Solutions displays Set 3 of 3 in the Data Translator Criteria screen where you enter the criteria for set 3, as shown in the following figure.

Data Translator Criteria Screen

1. Type DASAMP.LASTNAME.TABLEK in the TABLE DATASET field.

2. Type FM in the RO column next to EMP-NUMBER.

   FM indicates that the search key is in EMP_NUMBER; you will specify a mask from the next screen that is displayed.

3. Press <Enter>.

File-AID/Data Solutions displays the Field Mask Criteria screen, as shown in the following figure.

Field Mask Criteria Screen

1. Type NNNYY in the Field Mask field to access the last 2 positions of EMP-NUMBER.
2. Press <PF3> (END) to continue.

File-AID/Data Solutions displays the Data Translator Criteria screen, as shown in the following figure.

Data Translator Criteria Screen

1. Type K in the RO column next to EMP-NUMBER.
2. Type R in the RO column next to EMP-LAST-NAME.
3. Press <Enter>.

File-AID/Data Solutions displays the Key Field Parameters screen, as shown in the following figure.

Key Field Parameters Screen

1. Type 1 in the Location field to indicate that the key in DASAMP.LASTNAME.TABLEK is in position 1-2.
2. Press <PF3> (END) to continue.

File-AID/Data Solutions displays the Result Field Parameters screen, as shown in the following figure.

Result Field Parameters Screen

1. Type 3 in the Result Location field to indicate that the replacement EMP-LAST-NAME is in positions 3-17 of DASAMP.LASTNAME.TABLEK.

2. Press <PF3> (END) to continue.

   File-AID/Data Solutions displays the Data Translator Criteria screen with the result criteria displayed next to the fields. See the following figure.
   Data Translator Criteria Screen Set 3

    Action  Sets  Display  Show  Options  Menu  Help
    -------------------------------------------------------------------------------
    File-AID/Data Solutions ------- Data Translator Criteria ----------------------
    COMMAND ===>                                                  SCROLL ===> PAGE
    TABLE DATASET ===> ‘USERID0.DASAMP.LASTNAME.TABLEK’
    SET  3 OF  3           EMPLOYEE-MASTER-FILE                     GBL = N SEL = N
    ---- FIELD LEVEL/NAME ------- -FORMAT- RO --------- Parameters ---------------+
    ******************************* TOP OF DATA ***********************************
    5 EMP-NUMBER                    5/AN   K
     KLOC(00001);KLEN(00002);KTYPE(CHAR);+
    5 EMP-LAST-NAME                15/AN   R
     RLOC(00003);RLEN(00015);RTYPE(CHAR);+
    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            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              6/GRP                                          
        15 EMP-DOB-MM               2/NUM
    Valid RO: S = Search, K = Key, D = Direct pointer, H = Hash to key, U = Unique
              R = Result, SR, KR, DR, HR, UR (for both), EP, FM
    Commands: SELect, View 

3. Press PF3 (END) to continue.

   File-AID/Data Solutions displays the Criteria Menu, as shown in the below figure.