Reflection Desktop Help & HowTo > File and Data Transfer > IBM File and Data Transfer > Configure File Transfer > AS/400 Tab (Transfer Settings Dialog Box) > Database Field Options Dialog Box

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 Session ribbon, from the Transfer group, click the Transfer Settings launcher:
Reflection Browser	On the Reflection menu, choose Tools and then File Transfer. In the Transfer dialog box, click the Settings button.
TouchUx	Tap the Wrench icon and then under Tools, select File Transfer. In the Transfer dialog box, click the Settings button.

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.

Related Topics