Order By Dialog Box
Getting there
-
Open the Transfer Dialog box.
The steps depend on your user interface mode.
User Interface Mode
Steps
The Reflection Ribbon
On the tab, from the group, click .
The Reflection Browser
On the Reflection menu, choose and then .
TouchUx
Tap the Wrench icon and then under , select .
-
If you are running a 3270 session, change the protocol to AS/400.
-
Click .
-
From the list, select .
-
Click .
-
-
Click . (It may be necessary to enter your user name and password.)
-
Select one or more host files from which to transfer data.
-
Click .
-
From the dialog box, click the 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 box)
Type directly into the statement box, or use the lists and buttons to build your SQL query.
|
|
In this box, add an ORDER BY clause to your SELECT statement to sort the records resulting from the query. You can sort only by fields specified in your SELECT statement. |
|
|
Use these SQL functions to perform calculations on fields. |
|
|
This box displays the fields in the selected file(s). For more information about a field, hover your mouse over the field name. |