Skip to content

SQL Tab on the Transfer Settings 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.

    Click Settings.

    From the Protocol list, select AS/400.

    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)

Use this tab to create SQL queries for extracting data from IBM System i (AS/400) files. Type text directly into the text boxes, or click any of the buttons on the right to open a dialog box to build a query.


From the Transfer dialog box, select at least one host file before you build your query. Reflection displays field information from the specified file to help you build the query.

If you need help building your SQL query, consult your SQL documentation.

Option Description
Select Start building your SELECT statement by specifying fields (or columns) to transfer.
Where In this box, add a WHERE clause to your SELECT statement. Specify one or more conditions that must be met for a record to be transferred.
Order by 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.
Group by 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.
Having In this box, add a HAVING clause to apply a condition to a function of the SELECT statement. To enable the Having box and dialog box, you must first add a GROUP BY clause.
Join by In this box, add a JOIN clause to your SELECT statement to specify how you want data from multiple files or members combined. To enable the Join by box and dialog box, you must have selected multiple files or members on the Host side of the Transfer dialog box.
Return records with missing fields When joining records from more than one file, there may be cases where a record cannot be found to complete the join.

More information