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.