Defining your second 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 as shown in the following figure.
Sets Pull-down Menu
- Tab to the Sets action bar item and press <Enter>.
- In the Sets pull-down type 2 and press <Enter> to insert a new criteria set.
- Press <PF7> to scroll to the top of data.
File-AID/Data Solutions displays Set 2 of 2 in the Data Translator Criteria screen where you enter the criteria for set 2, as shown in the following figure.
Data Translator Criteria Screen
-------------------------------------------------------------------------------
File-AID/Data Solutions ------- Data Translator Criteria ----------------------
COMMAND ===> SCROLL ===> CSR
TABLE DATASET ===> DASAMP.LASTNAME.TABLEU
SET 2 OF 2 EMPLOYEE-MASTER-FILE GBL = N SEL = N
---- FIELD LEVEL/NAME ------- -FORMAT- RO --------- Parameters ---------------+
******************************* TOP OF DATA ***********************************
5 EMP-NUMBER 5/AN U
5 EMP-LAST-NAME 15/AN R
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
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
- Type DASAMP.LASTNAME.TABLEU in the TABLE DATASET field.
- Type U in the RO column next to EMP-NUMBER.
- Type R in the RO column next to EMP-LAST-NAME.
- Press <Enter>.
File-AID/Data Solutions displays the Unique Field Parameters screen as shown in the following figure.
Unique Field Parameters Screen
Type 1 in the Order field.
As multiple fields can be used together to create a composite field that will then be used as the input value for the unique translation you must specify the order in which the multiple fields are to be concatenated before being used to locate the translate table entry. Must be 1-9 and sequential beginning with 1.
This indicates that this is the first field of a composite field. In this example it is the first and only field.
Type N in the Retain Table field.
This indicates that the Unique Value table will not be saved after performing the unique translate.
- 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
Type 1 in the Result Location field.
This indicates that the new last names begin in position 1 of our translate table dataset.
- Press <PF3> (END) to continue.
File-AID/Data Solutions redisplays the Data Translator Criteria screen with the result criteria displayed next to the fields. See the following figure.
Data Translator Criteria Screen
-------------------------------------------------------------------------------
File-AID/Data Solutions ------- Data Translator Criteria ----------------------
COMMAND ===> SCROLL ===> PAGE
TABLE DATASET ===> ‘USERID0.DASAMP.LASTNAME.TABLEU’
SET 2 OF 2 EMPLOYEE-MASTER-FILE GBL = N SEL = N
---- FIELD LEVEL/NAME ------- -FORMAT- RO --------- Parameters ---------------+
******************************* TOP OF DATA ***********************************
5 EMP-NUMBER 5/AN U
FLEN(00005);ORDER(1)
5 EMP-LAST-NAME 15/AN R
RLOC(00001);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
Related topics