Database Field Options Dialog Box
Getting there
-
Open a 3270 or 5250 terminal session.
The steps depend on your user interface mode.
User Interface Mode
Steps
Ribbon
On the ribbon, from the group, click the launcher:
Reflection Browser
On the Reflection menu, choose and then . In the Transfer dialog box, click the button.
TouchUx
Tap the Wrench icon and then under , select . In the Transfer dialog box, click the button.
-
From the list, select .
-
Click the tab.
-
Click the button.
Set format options for the database fields you receive from the host.
- Time
-
Select the time format for selected fields with an IBM System i (AS/400) field type of Time. The options are:
Format given by IBM System i (AS/400) file attribute.
IBM System i (AS/400) job default (default).
IBM European standard (hh.mm.ss).
Hour, minute, second (hh:mm:ss).
International Standards Organization (hh.mm.ss).
Japanese Industrial Standard (hh:mm:ss).
USA standard (hh:mm AM or PM).
Select a character to use as a time separator in selected fields having an IBM System i (AS/400) field type of Time.
- Date
-
Select the date format for selected fields having an IBM System i (AS/400) field type of Date. The options are:
Format given by IBM System i (AS/400) file attribute.
IBM System i (AS/400) job default (default).
Day, month, year (dd/mm/yy)
IBM European standard (dd.mm.yyyy).
International Standards Organization (yyyy/mm/dd).
Japanese Industrial Standard (yyyy-mm-dd).
(yy/ddd)
Month, day, year (mm/dd/yy).
USA standard (mm/dd/yyyy).
Year, month, day (yy/mm/dd).
Select a character to use as a date separator in selected fields having an IBM System i (AS/400) field type of Date.
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.
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.
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:
Uses the EBCDIC hexadecimal sort sequence.
Uses the IBM System i (AS/400) job default.
Uses a shared weight table.
Uses a unique weight table.