Receiving Part of an iSeries, eServer i5, or System i5 File

Specify the following items:
Library/File (Member) INVENTORY
SELECT PARTNUM, QONHAND
WHERE QONHAND < 100
ORDER BY PARTNUM
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).
The following data is transferred:
     Field:   PARTNUM  QONHAND
              -------  -------
  Record 1:      207       75
         2:      209       50
         3:      295       85