The Upload Options tab defines how the host should accept the PC file you are uploading. It prepares the PC file so that it
can exist on the AS/400 in the proper format by:
|
• |
defining file properties |
|
• |
selecting the FDF description file |
|
• |
the file type (source or data) |
To define your Upload Options, follow these steps:
|
2. |
Once the Upload options dialog box opens, click the Upload Options tab. |
|
3. |
Select the type of file to upload in the File Type drop-down list in the PC File panel. If you have an FDF file to accompany this PC file, select the Use FDF description file checkbox and type the file name and path of this FDF file. You can use the Browse button to select the FDF file on your
PC.
The available PC file types are:
|
• |
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-characterss 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. |
Type the library and member name of the host file that will receive the PC file in the To: Library/File (Member) field in
the Host File panel. |
|
5. |
Select what to do with the host file or member when the transfer begins:
|
• |
Replace member — if the member exists on the host, it is erased and replaced by the contents of the PC file being transferred.
|
|
• |
New member — the host must create the member you specified in the To: Library/File (Member) field
|
|
• |
New file and member — the host must create the file and member you specified in the To: Library/File (Member) field
|
Note If you select either the New member or New file and member radio buttons, you must also specify the Type, Authority, and a
description of the new object. For more information on these panels, see Creating a New File and Member.
|
|
6. |
Click OK or click the Date/Time options tab. |