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.
ETU400 User Guide 011603 |
