Receiving Part of an iSeries, eServer i5, or System i5 File
Specify the following items:
In this case, only part of the INVENTORY file is to be transferred.
Specifically, only the part number (PARTNUM) and quantity on hand
(QONHAND) fields of the records for which the number of parts in stock
is less than 100 (QONHAND < 100) are transferred. Records are transferred
in ascending order of parts numbers (PARTNUM).
Library/File (Member) | INVENTORY |
SELECT | PARTNUM, QONHAND |
WHERE | QONHAND < 100 |
ORDER BY | PARTNUM |
The following data is transferred:
Field: PARTNUM QONHAND
------- -------
Record 1: 207 75
2: 209 50
3: 295 85