Order By Dialog Box
Getting there
- Open a 3270 or 5250 terminal session.
- On the Session ribbon, from the Transfer group, click 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.
Type directly into the statement box, or use the lists and buttons to build your SQL query.
|
Finished statement
|
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.
|
|
Functions
|
Use these SQL functions to perform calculations on fields.
|
|
Fields
|
This box displays the fields in the selected file(s). For more information about a field, hover your mouse over the field name.
|
|