Nlynx ETU400 Manual Do Utilizador

ETU400 User Guide 011603

 

ETU allows you to transfer selected records from a host file to a file on

a micro. You select the records to be transferred by creating test cases.

A test case is a set of criteria you specify within the PWRFROM3XB

command. You can specify up to 15 test cases. If a record meets the

criteria of a test case, it is transferred.

For instance, if you are transferring the employee file described

earlier, you can create a test case that transfers only the records of

those employees making more than $20,000. You could describe this test

case as follows: If the value in the PAYRAT field is greater than 20,000,

then transfer the record.

The PWRFROM3XB command contains four parameters under the heading RECSEL

(record selection). For each test case you create, you will supply the

relationship, the field to be tested, the relational operator, and the

comparison value. You can create up to fifteen test cases for a single

file transfer. These parameters are explained below.

Relates one test case to another. The first test
case must use *IF. The default, *NONE, transfers

all records in the file.

The other relationships are *AND, *OR, *ANDIF,

*ORIF and are used in situations where more than

one test case is evaluated.

Field to be tested 

Specifies the name of the field to be tested. Use
any field name from the file that was specified

in the FRMFILE parameter. If you use field

selection, you must specify a field to be tested.

Relational operator 

Specifies the relationship between the field to
be tested and the comparison value. The operators

are:

*EQ

Equal to

*NE

Not equal to

*GT

Greater than

*LT

Less than

*LE

Less than or equal to

*GE

Greater than or equal to

Specifies the value to which to compare the data
in the field to be tested. Enter a numeric value

for numeric fields, and an alphabetic value for

alphabetic fields. Alphabetic values must be

enclosed in single quotation marks (').

NOTE: If you specify an alphabetic comparison value in which a space is
used to separate words or characters (e.g., 'red apple'), the records

will transfer as expected. However, due to a limitation in the AS/400

operating system, a saved request definition with a comparison value as
described will not work properly.