AS/400 Transfer Method Options

Use the Transfer method setting in the Transfer dialog box to specify how data in files is processed during transfers.

NOTE:This setting does not affect transfers to the host when you are using a description file to keep data in the intended format. Reflection uses description files by default. You can change this configuration from the Options tab of the Transfer Settings dialog box.

The options available depend on the file transfer protocol you have selected. For AS/400 transfers, the options are:

ASCII	Use for files with no special formatting, and fixed record widths.
Basic Sequential	Use to separate all fields with commas, and insert quotation marks around character and hexadecimal fields.
CSV	Use to separate fields with commas, and insert quotation marks only around character fields that contain a comma or quotation mark.
DIF	Use for files transferred to and from Microsoft Excel — DIF files contain the field names.
DOS Random	Use for data transferred to and from the host from host database applications that require data to be in DOS Random format.
No Conversion	Use for files that should not be translated — files transferred as No Conversion are not translated to the EBCDIC character set during a transfer to the host.
Tab Delimited	Use to separate all fields with tabs, and insert quotation marks only around character fields that contain a quotation mark.