Database Field Options Dialog Box

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

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).

Separator

Select a character to use as a time separator in selected fields having an AS/400 field type of Time.

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).

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.