Skip to content

Join By Dialog Box

How do I get to this dialog box?
  1. Open the Transfer Dialog box.

    The steps depend on your user interface mode.

    User Interface Mode Steps
    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.
    TouchUx Tap the Wrench icon and then under Tools, select File Transfer.
  2. If you are running a 3270 session, change the protocol to AS/400.

    1. Click Settings.

    2. From the Protocol list, select AS/400.

    3. Click OK.

  3. Click Show Host Files. (It may be necessary to enter your user name and password.)

  4. Select one or more host files from which to transfer data.

  5. Click Settings.

  6. From the Transfer Settings dialog box, click the SQL tab.

  7. 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 Joins box, or use the lists and buttons to build your SQL query.

Option Description
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.

More information