The PC File tab defines how the PC file should receive the host file you are downloading.
To define your Download Options, follow these steps:
|
1. |
Click the PC File tab on the Download options dialog box. |
|
2. |
If you want to create an FDF file that contains the structure of the host member you want to download, select the Create FDF description file checkbox and type the file name and path of this new FDF file. Use the Browse button to select the path in which to create or select the FDF file on your PC.
|
|
3. |
Select the file type that most closely applies to your type of file from the File Type drop-down list. You have the following choices:
|
• |
ASCII — these files contains fields in ASCII data. A carriage return (ASCII 0D) and a line feed (ASCII 0A) delimit each record.
An end of file (ASCII 1A) specifies the end of the ASCII file.
|
|
• |
DOS Random and DOS Random 2 — these fixed length files are used by the DOS random read and write routines. These files do not have end-of-record or end-of-file
markers. Records are defined by their constant length, relative positions, and the length of the file.
|
|
• |
BASIC Sequential — this is a database file in the BASIC language for sequential processing (also known as Comma Separated Values (CSV)). Each
field in the file is considered either character or numeric. This is the standard format for imported data in database packages
such as Microsoft Access and FoxPro.
|
♦ |
Each field is displayed as displayable characters with text fields enclosed in quotation marks (ASCII 2B). |
|
♦ |
Fields are separated by a comma (ASCII 2C) with a record ending with a carriage return (ASCII 0D) and a line feed (ASCII OA).
|
|
♦ |
Records and fields are of variable length. |
|
|
• |
BASIC Random — this file type is used in the BASIC programming language. It contains fixed length records with no delimiters between fields
or records. BASIC Random holds numeric values in a specific format.
|
|
• |
No Conversion — the data in these files has been preserved during the transfer. For example, when you transfer a No Conversion file, its
data is downloaded so that its format in the target file is identical to the source file.
|
|
• |
Source — this file format is a text file with a line structure or one field structure. On the host, a 12-character header is found,
with 6 bytes for the sequence value and 6 bytes for the date for each line. A source file is the best file type when you are
transferring standard text or source data.
|
♦ |
When downloaded from a source file, this header is removed. |
|
♦ |
When uploaded, each line will have this header appended to each record. |
|
|
• |
To Restore — a file format identical to the format of your PC files. The data in these files has not changed in the file transfer; the
uploaded data on the AS/400 is exactly the same as the data on the PC.
|
|
• |
Tabbed — this file format is similar to the ASCII file format, except that the fields are separated by a TAB space (ASCII 09).
|
|
• |
Date Interchange Format (DIF) — this file format is a program-independent method of storing data. DIF files are ASCII text files and are oriented towards
row-and-column data, such as a spreadsheet. DIF files contain two sections: a file header and a data section. This format
is supported by Microsoft Excel.
|
|
|
4. |
Once you select the PC file type, you have three options:
|
• |
Click the Date/Time options tab.
|
|
• |
Click the Advanced SQL tab.
|
|