ETU400 User Guide 011603
9-17
Record Selection -- Example1
Suppose you want to transfer the employee file (described in the previous
section) from the host to the PC. You will transfer only the records of
those employees earning more than $20,000 per year. To do this you will
create a test case that transfers the records that meet the following
criterion: the value in the PAYRAT field is greater than 20,000.
1.
Enter the file transfer and translation information as you would for
any file transfer.
2.
In the RECSEL Relationship parameter, enter
*IF
.
3.
Enter
PAYRAT
for the field to be tested. Enter
*GT
(greater than) as
the relational operator. Enter 20000 for the comparison value.
When you initiate the command, the records that meet the above criteria
are transferred.
Record Selection -- Example 2
This example shows you how you can use more than one test case to select
records. It uses the same employee file as in the other examples.
Suppose you want to transfer a file from the host to a PC. You will
transfer only the records that meet the following set of criteria: the
value in the PAYRAT field is greater than 20000 and the employee has five
or more years of service with the company.
1.
Enter the file transfer and translation information as you would with
any file transfer.
2.
Enter a plus sign ( ) next to the RECSEL parameter and press ENTER.
This displays 15 prompts, each containing the following parameters:
relationship, field to be tested, relational operator, and comparison
value.
3.
In the first prompt, for the relationship, enter
*IF
. Enter PAYRAT for
the field to be tested. Enter
*GT
(greater than) as the relational
operator. Enter
20000
for the comparison value.
4.
In the second prompt, enter
*AND
as the relationship. Enter
YEARS
for
the field to be tested. Enter
*GE
(greater than or equal to) as the
relational operator. For the comparison value, enter
5
.
When you initiate the command, all records meeting both sets of criteria
will be transferred to the PC.
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...
