ETU400 User Guide 011603
9-16
Transferring Selected Records
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.
Relationship
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
Comparison value
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.
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...
