Join 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 Joins box, or use the lists and buttons to build your SQL query.
|
Joins
|
In this box, add a JOIN clause to your SELECT statement to specify how you want data from multiple files or members combined.
|
|
Fields
|
This box displays the fields in the selected file(s). For more information about a field, hover your mouse over the field name.
|
|
Tables
|
This box displays the files or members selected on the Host side of the Transfer dialog box.
|
|