Nlynx ETU400 - Manual (Page 121)

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.