Receiving a Summary of Record Groups

A summary record is a single record that includes information on each set of records grouped from one or more iSeries, eServer™ i5, or System i5® files.

The FROM items are as follows:
System name
This item specifies the name of the system.
Library/File (Member)
This item specifies the names of all files from which data is to be transferred.
JOIN BY
This item is optional. It specifies the join conditions that must be satisfied before records can be joined.
GROUP BY
This item is optional. It must be specified only when the records of iSeries, eServer i5, or System i5 files are classified into several groups. To group all records into a single group, this item need not be specified.
SELECT
Specifying this item creates a summary record. The field names specified in GROUP BY can be specified.
WHERE
This item is optional. It specifies the requirements that each record to be grouped must satisfy. To group all records, this item need not be specified.
HAVING
This item is optional. It specifies the summary record to be transferred. To transfer all summary records, this item need not be specified.
ORDER BY
This item is optional. It specifies how summary records will be grouped. When this item is left blank, records are not grouped (data is transferred in the same order as it appears in the iSeries, eServer i5, or System i5 file).