Field List for Input Settings

Table 2.2 Field List for Data Processing Information (Input Settings)

Field name

Initial value

Possible settings

Omission possible

Remarks

Format

The format of the icon placed in the input area.

CSV, Format, Multi Format, Hierarchy Format, XML, Text, Excel, Database Table

No

 

Comment

 

Characters

Yes

255 bytes or fewer

Layout (Common)

 

ID (#2)

 

Alphanumeric characters and symbols (#1)

No

50 bytes or fewer

File name (#5)

 

Windows

Characters (#3)

No

200 bytes or fewer

UNIX

Alphanumeric characters and symbols (#4)

Handling of 0 records

Abnormal

Abnormal, Normal

No

 

Standard input (#16)

OFF

ON, OFF

Yes

 

Layout (CSV)

 

Omit ID

OFF

ON, OFF

No

 

Delimiter

,

(,), ! #, $, %, &, (, ), ^, |, ~, \, $TAB, $SPACE, $NULL, Enter hexadecimal value

Yes

You can specify settings when the Omit ID is selected.

Delimiter(hexadecimal)

 

Hexadecimal character

*4

Enclosure character

"

", #, $, %, &, ', (, ), ^, |, ~, \, $TAB, $SPACE, None, Enter hexadecimal value

Yes

Enclosure character (hexadecimal)

 

Hexadecimal character

*4

Check number of fields

OFF

ON, OFF

No

You can specify settings when the Omit ID is not selected.

Use header record

OFF

ON, OFF

No

 

Number of rows for the header record

 

1 to 99

*1

 

Handling of fields not valid for CSV sort key

Do not allow

Allow, Do not allow

No

 

Layout (Format, Multi Format, Hierarchy Format)

 

Numeric value byte order

Same as host

Same as host, Big-endian, Little-endian

No

 

Layout (XML)

 

XML record unit

Element

1, 2, 3, Element

No

 

Layout (Excel)

 

-

-

-

 

 

Layout (Database Table)

 

Numeric value byte order

Same as host

Same as host, Big-endian, Little-endian

No

 

Handling of null values in numeric fields

Zero (0)

Zero (0), Null

No

 

Layout (Text)

 

Enable mapping

OFF

ON, OFF

No

 

Code conversion

 

Kanji code type (#6)(#15)

(#7)

Shift JIS, JEF, EUC, IBM kanji, KEIS, NEC kanji, UTF-16, UTF-8, JIS

No

 

Unicode byte order (#14)(#15)

Same as host

Same as host, Big-endian, Little-endian

No

 

Line break code (#8)

0D0A (#12)

Hexadecimal characterHexadecimal character

No

UTF-16: 4, or 8 bytes

Other than UTF-16: 2, or 4 bytes

EBCDIC set (#9)(#15)

EBCDIC kana

EBCDIC kana,

EBCDIC lowercase,

EBCDIC ASCII,

EBCDIC ASPEN,

Japan (Latin) for IBM,

Japan (Latin) Extended for IBM,

NEC Katakana,

Japan (Katakana) Extended for IBM,

ASCII (#13)

No

 

Convert characters other than of JIS Level 1 or JIS Level 2 (#11)(#15)

ON

ON, OFF

No

 

Sorting

 

Sort input data

OFF

ON, OFF

No

 

No.

 

Display only

 

 

Field No.

 

Display only

 

 

Field Name

 

Display only

 

 

Type

Characters

Characters, Numeric value, Date

Yes

 

Sort order

Ascending

Ascending, Descending

Yes

 

Merging (#10)

 

File name

 

Windows

Characters (#3)

*2

200 bytes or fewer

UNIX

Alphanumeric characters and symbols (#4)

Delete duplicate lines

OFF

ON, OFF

No

 

Merge keys

 

No.

 

Display only

 

 

Field No.

 

Display only

 

 

Field name

 

Result of the Select field screen

*3

 

Priority keys

 

 

 

No.

 

Display only

 

 

Field No.

 

Display only

 

 

Field name

 

Result of the Select field screen

*3

 

Type

Characters

Characters, Numeric value, Date

Yes

 

Sort order

Ascending

Ascending, Descending

Yes

 

#1

:

You can use only hyphen (-), underscore (_), period (.), left parenthesis ((), and right parenthesis ()).

#2

:

You cannot specify this field if Format is Text. You can omit this field for CSV.

#3

:

External characters cannot be used. Operations are not guaranteed if you use any platform-dependent characters.

#4

:

You cannot specify left angle brackets (<), right angle brackets (>), double quotation marks ("), single quotation marks ('), or ampersands (&).

#5

:

If Format is Database Table, you cannot make this setting.

#6

:

If Format is CSV, XML, or Database Table, select from EUC, Shift JIS, UTF-8, or UTF-16.

If Format is Excel, this setting is fixed to UTF-8 and cannot be changed.

#7

:

The value of Encoding of input and output files (cs4file) in the system environment settings file (huledenv.conf) is applied.

Note that when Format is CSV, XML, or Database Table, if the Encoding of input and output files (cs4file) is set to a character encoding that cannot be initially displayed (encoding other than the open standard character encodings, Shift JIS, EUC, UTF-8, and UTF-16), the value of Local host kanji code type (knjcode) is used.

#8

:

You can specify this field only if Format is CSV or Text.

#9

:

You can select it if Format and Kanji code type is specified as below.

  • The format is Format, Multi format, Hierarchy format, or Text.

  • The kanji code type is JEF, IBM kanji, KEIS, NEC kanji, or JIS.

#10

:

You can make this setting only if Format is CSV or Format.

#11

:

You can select it if Shift JIS, IBM kanji, UTF-8, or UTF-16 is specified for Kanji code type.

#12

:

In the case of logged in DataMagic Server for UNIX/Linux, the initial value is 0A. The initial value for the line break code is NULL only if the Kanji code type is KEIS.

#13

:

You can select it if JIS is specified for Kanji code type.

#14

:

You can select it if UTF-16 is specified for Kanji code type.

#15

:

In the case of DataMagic Desktop grade, this is displayed but cannot be changed.

#16

:

You cannot specify this setting if the format is set to Hierarchy format, XML, Excel, or Database Table.

*1

:

Input is required if the Use header record is selected.

*2

:

Input is required if the Merged file icon has been created.

*3

:

Input is required if Delete duplicate lines is selected.

*4

:

Displays the Enter hexadecimal value has been selected for Delimiter or Enclosure character.