9.3.1 Transfer Data to and from an AS/400 (5250)

NOTE:If you plan to perform a transfer regularly, you can save your transfer settings in a transfer request file.

To send data to a member of a file on an AS/400

  1. In a 5250 session, open the File 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.

    Classic or Classic MDI

    On the Tools menu, choose Transfer File.

    The Reflection Browser

    On the Reflection menu, choose Tools and then File Transfer.

  2. Click the Settings button to open the Transfer Settings dialog box.

  3. On the AS/400 tab, specify the host to send the data to and the credentials (Username and Password) you want to use to log on to the host.

    NOTE:You can transfer data to a host other than the host your session is connected to.

  4. On the Options tab, under To host, browse to the Description .FDF file that was created when you downloaded the file from the host. (Reflection creates this file by default when you download a file.)

  5. In the Objects list, select one of the options to create a new member or replace an existing member.

  6. If you are creating a new member in a file, enter a description in the Member text box. (This step is optional.) This text description is displayed when you view the files in your application.

  7. On the Translation tab, specify how to handle filename spaces, underscores, length, and case and click OK.

  8. From the Transfer dialog box, under Local, do one of the following:

    • Browse under Local folders, and then select one or more files from the list.

      -or-

    • Type the path and filename into the File names box.

    NOTE:You can transfer more than one file only if the description .FDF file you are using applies to all the files.

  9. Under Host, specify which host file and member should receive the data using one of the following techniques:

    • To create a member, click Show Host Files and browse to select a host file or type the file information in the File names box, using this syntax: LIBRARY/FILE

      -or-

    • To replace a member, click Show Host Files and browse to select a host file and member or type the file information in the File names box, using this syntax: LIBRARY/FILE(MEMBER)

      NOTE:If InfoConnect 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.

  10. To initiate a file transfer, do one of the following:

    • Click the Transfer button.

      -or-

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

To send data to a new file and member on an AS/400

  1. In a 5250 session, open the File 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.

    Classic or Classic MDI

    On the Tools menu, choose Transfer File.

    The Reflection Browser

    On the Reflection menu, choose Tools and then File Transfer.

  2. Click the Settings button to open the Transfer Settings dialog box.

  3. On the AS/400 tab, specify the host to send the data to and the credentials (Username and Password) you want to use to log on to the host.

    NOTE:You can transfer data to a host other than the host your session is connected to.

  4. On the Options tab, under To host, browse to the Description .FDF file that applies to the file you are transferring. (Reflection creates this file by default when you download a file.)

  5. To create a new file and member, in the Objects list, select Create File and Member and then enter the following settings:

    • In File type, select the type of file to create (Data or Source).

    • In the Authority list, choose the type of file permissions (for example, Read/Write) for the file.

    • To add a description for the file, enter a description in the File text box. (This is optional.) The text description is displayed when you view the files in your application.

    • To add a description for the member, enter a description in the Member text box. (This is optional.) The text description is displayed when you view file members in your application.

    • In the Reference file box, specify a reference file to use for the file you are sending, using the following syntax:

      library_name/filename

      The new host file is created using the field names in the description file and the definitions of the fields in the reference file.

      NOTE:A reference file is a physical file that defines the fields used in other files. You can create a field reference file that contains only the field descriptions that you need for any group of files or you can specify a file that has the same fields as the file you are creating.

  6. On the Translation tab, specify how to handle filename spaces, underscores, length, and case and click OK.

  7. From the Transfer dialog box, under Local, enter the file you want to transfer:

    • Browse under Local folders, and then select the file from the list.

      -or-

    • Type the path and filename into the File names box.

  8. Under Host, enter the library and the new host file in the File names box, using this syntax:

    LIBRARY/FILE(member)

    NOTE:If InfoConnect 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.

  9. To initiate a file transfer, do one of the following:

    • Click the Transfer button.

      -or-

    • Drag the source file, and then drop it on a host library.

To receive data from an AS/400

  2. Click the Settings button, and configure the file transfer settings.

  3. On the AS/400 tab, specify the host to receive the data from and the credentials (Username and Password) you want to use to log on to the host.

    NOTE:You can transfer data from a host other than the one your session is connected to.

  4. On the Options tab, under From host, specify how you want InfoConnect to handle AS/400 transfers and select one of the following options in the Output to list.

    Choose this option

    To...

    Display

    Display the file in the Query Results display window.

    File

    Send the data to a file.

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

    Spreadsheet

    Save the file in a DIF file that can be opened in a spreadsheet.

  5. On the Translation tab, specify how to handle filename spaces, underscores, length, and case and click OK.

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

    Field information about the host file you selected is available when you click an arrow next to a field.

  7. In the Transfer dialog box, under Host, specify the host file from which to receive data as follows:

    • Click Show host files, and browse to select one or more host files. 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.

      -or-

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

      NOTE:If InfoConnect 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.

  8. In the Transfer method list, select how data conversion should be handled.

  9. If you chose to transfer the data to a file, choose the file to receive the data under Local, in the File names box.

    • If you chose to output to a file on the Options tab, enter the file name and extension.

    • If you don’t choose a file, the file is saved with the name of the file on the host.

    NOTE:If you chose to output to a spreadsheet on the Transfer Settings options tab, the file is automatically transferred as a DIF file.

  10. To initiate a file transfer, do one of the following:

    • Click the Transfer button.

      -or-

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