ETU400 User Guide 011603
9-15
Field Selection -- Example 2
In this example, you will see how you can use more than one key field
when transferring selected fields. You will transfer the same file as in
the first example.
This time, you will transfer the employee names and their rates of pay.
You will sort the information first in order of highest salary to lowest
salary, and second, in alphabetical order when two or more employees earn
the same salary. Table 9-2 below illustrates how the file will appear on
the PC.
Table 9-2 Transferred data for Example 2
Salary
Employee name
10,000
Spock
15,000
Anderson
20,000
Stiles
30,000
Brandybuck
65,000
Dilbert
75,000
Wally
80,000
Martinez
90,000
Haram
100,000
Simpson
1.
Enter the file transfer and translation information as you would with
any file transfer.
2.
In the FLDSEL parameter, next to the field name prompt, enter a plus
sign ( ) and press ENTER. This displays multiple prompts.
3.
In the first prompt, for field name, enter PAYRAT (rate of annual
pay). For key field, enter *KEY1. This tells ETU that the PAYRAT field
is a key field with the highest sort priority. For ascending or
descending, enter *DES. This tells ETU to sort the records in the
order of the highest salary to the lowest salary.
4.
In the second prompt, for field name, enter EMPNAM. For key field,
enter *KEY2. This sorts any employees who earn the same salary in
alphabetical order. Enter *ASC to sort the employees from A to Z.
Summary of Contents for ETU400
Page 1: ...i ETU400 User Guide AS 400FileTransferUtility...
Page 30: ...ETU400 User Guide 011603 2 5 old versions since most users do not modify these tables...
Page 183: ...ETU400 User Guide 011603 10 53...
Page 239: ...ETU400 User Guide 011603 E 1 Appendix E ERRORMESSAGES NATIVEMODE...
Page 264: ...ETU400 User Guide 011603 F 1 Appendix F ASCII EBCDICPRINTABLECHARACTERS...
Page 304: ...ETU400 User Guide 011603 H 1 Appendix H INTERNATIONALTRANSLATIONTABLES...
Page 309: ...ETU400 User Guide 011603 J 1 Appendix J ETUTHROUGHPUTCONSIDERATIONS...
