You can choose from several date, time, and data options for the ActiveX File Transfer control. These options not only define
how the data and time appear in the PC file, but also how data is separated.
Notes
|
1. |
If the current selection in a drop-down list is AS/400 Job Default or Host Job Default, this means that the AS/400/Host determines
this value. Any selection you make in this dialog box overrides the AS/400/Host default.
|
|
2. |
These options are identical for both downloading and uploading files. |
To define the date, time, and data options, follow these steps.
|
1. |
Click the Date/Time Options tab from the Upload options dialog box. |
|
2. |
Select how the time should appear from the Time Format drop-down list. All time values appear as Hours, Minutes, and Seconds.
The separator appears in the Time Separator according to the style currently selected. You have the following options:
|
|
Hours Minutes Seconds formats the hours as ranging from 1 to 12 with no distinction between morning and afternoon hours. You can choose any separator in the Time Separator drop-down list.
|
|
|
International Standards Organization (ISO) formats time over a range of 24 hours (2:05 p.m. appears as 14:05). Simply add twelve hours to afternoon time to obtain
the ISO time. The separator for this format is the comma (ASCII 44).
|
|
|
USA Standard formats time over a range of 12 hours with an additional indicator for morning (AM) and afternoon (PM) hours. The separator for this format is the colon (ASCII 58).
|
|
|
IBM European Standard formats time over a range of 24 hours as ISO. The separator is the period (ASCII 46).
|
|
|
Japanese Industrial Standard Christian Era formats time over a range of 24 hours according to ISO. The separator is a colon (ASCII 58).
|
|
|
AS/400 Data Description Specifications formats time as defined by the AS/400 file attribute.
|
|
|
AS/400 Job Default formats time as specified by the host job.
|
|
|
3. |
Select how the date should appear from the Date Format drop-down list. Date values appear differently for each format. An
example appears next to the selection. The letter "D" represents the day, the letter "M" for the month, and the letter "Y"
for the year. The number of letters identifies how the corresponding value appears. For example, DD means days of the month
from 1 to 31 while DDD means days of the year from 1 to 365. The date separator for the date format appears in the Date Separator
drop-down list.
|
|
Month Day Year (mm/dd/yy), Day Month Year (dd/mm/yy), and Year Month Day (yy/mm/dd) formats the date according to the order specified in the format name. You can select the date separator for these formats from the Date Separator drop-down list.
|
|
|
Julian (yy/ddd) formats the year as two digits and the day from 1 to 365. You can also specify the separator. For example, Valentines day (February 14) appears as day 45 (31 days for January plus
14 days in February).
|
|
|
International Standard Organization (ISO) (yyyy-mm-dd) formats the year as a four-digit number, the month as a two-digit number, and the day of the month.
|
|
|
USA Standard (mm/dd/yyyy) formats the month as two-digit number, the day of the month as a two-digit number, and the year as a four-digit number.
The separator is a period (ASCII 46).
|
|
|
IBM European Standard (dd/mm/yyyy) formats the day of the month as a two-digit number, the month as a two-digit number, and the year as a four-digit number.
The separator for this format is the period (ASCII 46).
|
|
|
Japanese Industrial Standard Christian Era formats the year as a four-digit number, the month as a two-digit number, and the day as a two-digit number. The separator is the dash (ASCII 45).
|
|
|
AS/400 Data Description Specifications formats provides the date according to the host file format. Select the Default button to return to this format.
|
|
|
AS/400 Job Default formats the date according to the host job default.
|
|
|
4. |
Select the Ignore Decimal data error in Host packed or zone fields checkbox to ignore decimal errors in AS/400 packed decimal and zoned decimal fields. |
|
5. |
Select the separator for the data file from the Data Separator drop-down list. There are three options:
|
|
The period ([.] or ASCII 46) |
|
|
The comma ([,] or ASCII 44) |
|
|
The PC standard which is the List Separator as specified in the International configuration of the Windows Control Panel.
|
|
|
6. |
Click OK when finished. |