Group By Dialog Box
 Getting there
- Open a 3270 or 5250 terminal session.
- Open the Transfer dialog box as follows:
If you are using this "look and feel"
|
Do this
|
The Reflection Ribbon
|
On the Session tab, from the Transfer group, click File Transfer.
|
The Reflection Browser
|
On the Reflection menu, choose Tools and then File Transfer.
|
- If you are running a 3270 session, change the protocol to AS/400.
- Click Settings.
- From the Protocol list, select AS/400.
- Click OK.
- Click Show Host Files. (It may be necessary to enter your user name and password.)
- Select one or more host files from which to transfer data.
- Click Settings.
- From the Transfer Settings dialog box, click the SQL tab.
- Open the dialog box by clicking the arrow
 next to the field (for example, to open the Select dialog box, click the arrow button for the Select box).
Type directly into the statement box, or use the lists and buttons to build your SQL query.
|
Finished statement
|
In this box, add a GROUP BY clause to your SELECT statement to specify how to group the resulting data after the requested calculation (function) is performed.
This clause is necessary when a function and multiple fields are specified in your SELECT statement.
|
|
Fields
|
This box displays the fields in the selected file(s). For more information about a field, hover your mouse over the field name.
|
|
