Database Field Options Dialog Box
Getting there
- Open a 3270 or 5250 terminal session.
- On the Session ribbon, from the Transfer group, click the Transfer Settings launcher:
- From the Protocol list, select AS/400.
- Click the AS/400 tab.
- Click the Fields button.
Set format options for the database fields you receive from the host.
Time
|
|
|
|
|
Time Format
|
Select the time format for selected fields with an AS/400 field type of Time. The options are:
|
|
|
DDS
|
Format given by AS/400 file attribute.
|
|
|
DFT
|
AS/400 job default (default).
|
|
|
EUR
|
IBM European standard (hh.mm.ss).
|
|
|
HMS
|
Hour, minute, second (hh:mm:ss).
|
|
|
ISO
|
International Standards Organization (hh.mm.ss).
|
|
|
JIS
|
Japanese Industrial Standard (hh:mm: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 AS/400 field type of Time.
|
Date
|
|
|
|
|
Date Format
|
Select the date format for selected fields having an AS/400 field type of Date. The options are:
|
|
|
DDS
|
Format given by AS/400 file attribute.
|
|
|
DFT
|
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 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 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 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 AS/400 job default.
|
|
|
*LANGIDSHR
|
Uses a shared weight table.
|
|
|
*LANGIDUNQ
|
Uses a unique weight table.
|
|