Show Contents / Index / Search

Receive Data from an AS/400

Note: If the transfer is one you'll be performing regularly, you can save your transfer settings in a transfer request file.

To receive data from an AS/400

  1. Start Reflection and log on to the host computer as usual.
  2. On the Session ribbon, from the Transfer group, click File Transfer.
  3. Click the Settings button, and configure the file transfer settings.
  4. From the AS/400, Options, and Translation tabs, specify the way you want Reflection to handle AS/400 transfers.
  5. Click OK.
  6. From the Transfer dialog box, under Host, specify the host file from which to receive data using one of the following techniques:
    • Click Show host files, and browse to select one or more host files. You can right-click on a file or member to view a brief description, if available. If the library containing the host file you need is not shown, click Add library and type the library name in the Add Library dialog box.


    • Type the file information using this syntax: LIBRARY/FILE(MEMBER).

      Note: If Reflection is configured to use a character set that is not supported by your host, you cannot display host files using the Show host files button.

  7. (Optional) To configure an SQL query, click Settings and from the SQL tab, build your query.

    Field information about the host file you selected becomes available when you select this tab.

  8. From the Transfer dialog box, specify a local destination for the data.

    To send data to

    Do this

    A file

    Specify a filename under Local.

    If you don't specify a filename, Reflection uses the host filename.

    A display window

    Click Settings, and then from the Options tab, set Output to to Display.

    A spreadsheet

    Click Settings, and then from the Options tab, set Output to to Spreadsheet.

    Data is saved to a .DIF file.

  9. To initiate a file transfer, do one of the following:
    • Click a Transfer button to move the file in the indicated direction.


    • Drag the source file, and then drop it on the desired destination file.

Related Topics

Drag-and-Drop Options for Receiving from an AS/400

Create an SQL Query

AS/400 Transfer Method Options

AS/400 Field Description Files

Send Data to an AS/400

AS/400 Transfer