Nlynx ETU400 Manual Do Utilizador

ETU400 User Guide 011603

 

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.

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.