Skip to content

Database Field Options Dialog Box

How do I get to this dialog box?

  1. Open the Transfer Settings dialog box.
    The steps depend on your user interface mode.

    User interface mode Steps
    Ribbon With a session open, on the Session ribbon, from the Transfer group, click the Transfer launcher:
    InfoConnect Browser With a session open, on the InfoConnect menu, choose Tools and then File Transfer. In the Transfer dialog box, click the Settings button.
    TouchUX With a session open, tap the Wrench icon and then under Tools, select File Transfer. In the Transfer dialog box, click the Settings button.
    Classic MDI With a session open, from the Setup menu, select File Transfer.

  2. From the Protocol list, select AS/400.

  3. Click the AS/400 tab.

  4. Click the Fields button.

Set format options for the database fields you receive from the host.

Time

Option Description
Time Format Select the time format for selected fields with an IBM System i (AS/400) field type of Time. The options are:
DDS Format given by IBM System i (AS/400) file attribute.
DFT IBM System i (AS/400) job default (default).
EUR IBM European standard (hh.mm.ss).
HMS Hour, minute, second (hh🇲🇲ss).
ISO International Standards Organization (hh.mm.ss).
JIS Japanese Industrial Standard (hh🇲🇲ss).
USA USA standard (hh:mm AM or PM).
Time Separator Select a character to use as a time separator in selected fields having an IBM System i (AS/400) field type of Time.

Date

Option Description
Date Format Select the date format for selected fields having an IBM System i (AS/400) field type of Date. The options are:
DDS Format given by IBM System i (AS/400) file attribute.
DFT IBM System i (AS/400) job default (default).
DMY Day, month, year (dd/mm/yy)
EUR IBM European standard (dd.mm.yyyy).
ISO International Standards Organization (yyyy/mm/dd).
JIS Japanese Industrial Standard (yyyy-mm-dd).
JULIAN (yy/ddd)
MDY Month, day, year (mm/dd/yy).
USA USA standard (mm/dd/yyyy).
YMD Year, month, day (yy/mm/dd).
Date Separator Select a character to use as a date separator in selected fields having an IBM System i (AS/400) field type of Date.
Ignore decimal data errors Select to ignore any decimal data errors found in a packed or zoned field during the transfer from the IBM System i (AS/400). Ignoring these errors speeds up the transfer process.
Decimal separator
Select the character to use as a decimal separator in selected fields that have an IBM System i (AS/400) field type of packed decimal or zoned decimal.
Sort sequence
Select a sort sequence for the data being transferred. This sequence determines the order of characters in the alphabet when fields are alphabetized. The sort sequence also affects any comparisons based on characters in the fields. The options are:
*HEX Uses the EBCDIC hexadecimal sort sequence.
*JOB Uses the IBM System i (AS/400) job default.
*LANGIDSHR Uses a shared weight table.
*LANGIDUNQ Uses a unique weight table.

More information