Field List for Virtual Table Settings

Table 2.7 Field List for Data Processing Information (Virtual Table Settings / Common)

Field name

Initial value

Possible settings

Omission possible

Remarks

Format

CSV

CSV, Format, Excel, Database Table

No

 

Comment

 

Characters

Yes

255 bytes or fewer

ID (#7)

 

Alphanumeric characters and symbols (#1)

No

50 bytes or fewer

Virtual table name

VT_TABLEx(#2)

Characters

No

255 bytes or fewer

Field list

 

Field number

 

 

 

 

Validity

ON

ON, OFF

No

 

Field name

 

Display only

 

 

No. of occurrences (#3)

 

Display only

 

 

Fixed/Variable length (#4)

 

Display only

 

 

No. of bytes (#4)

 

Display only

 

 

Field type

(#5)

Display only

 

 

Virtual table field name

(#6)

Display only

 

 

#1

:

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

#2

:

The part marked x is replaced with the serial number.

#3

:

This field is displayed only if Format is selected for Format.

#4

:

This field is displayed only if Database Table is selected for Format.

#5

:

Field types obtained from layout information initially display the following content.

Layout information field type

Display format

M、N、X

Character string

F、Z、9、P、S、B

Numeric value

D

Date

I

Binary

#6

:

The initial value varies depending on Format.

For Format and Database Table:

:

The layout information field name is displayed in uppercase. If the same field name exists, the virtual table field name is displayed as Field name_x. The part marked x is replaced with the serial number.

For CSV with ID specified:

:

The layout information field name is displayed in uppercase.

For CSV data with no ID specified:

:

The virtual table field name is displayed as NO_x. The part marked x is replaced with the serial number.

#7

:

You can omit this field if Format is CSV.

 

Table 2.8 Field List for Data Processing Information (Virtual Table Settings / Format = CSV)

Field name

Initial value

Possible settings

Omission possible

Remarks

Layout

 

Omit ID

OFF

ON, OFF

No

 

Delimiter

,

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

Yes

You can specify settings when the Omit ID is selected.

Enclosure character (hexadecimal)

 

Hexadecimal character

*1

Enclosure character

"

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

Yes

Enclosure character (hexadecimal)

 

Hexadecimal character

*1

File name

 

Windows

Characters (#1)

No

Up to 200 bytes

UNIX

Alphanumeric characters and symbols (#2)

Use header record

OFF

ON, OFF

No

 

Number of rows for the header record

 

1 to 99

*2

 

Code conversion

 

Kanji code type (#5)

(#3)

SHIFT-JIS、EUC、UTF-16、UTF-8

No

 

Unicode byte order (#4)(#5)

Same as host

Same as host
Same as host, Big-endian, Little-endian

No

 

Line break code (#6)

(#7)

Hexadecimal character

Yes

UTF-16:

4 or 8 bytes

Other than UTF-16:

2, or 4 bytes

#1

:

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

#2

:

You cannot specify left angle brackets (<), right angle brackets (>), double quotation marks ("),

single quotation marks ('), or ampersands (&).

#3

:

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

Note that if 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.

#4

:

This is displayed if UTF-16 is selected as the kanji code.

#5

:

In the case of DataMagic Desktop grade, this is not displayed.

#6

:

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

#7

:

The initial value for the line break code depends on the OS where DataMagic Server runs. In DataMagic Desktop grade, the value is 0D0A.

*1

:

Input is required if Enter hexadecimal value has been selected for Delimiter or Enclosure character.

*2

:

Input is required if the Use header record is selected.

 

Table 2.9 Field List for Data Processing Information (Virtual Table Settings / Format = Format)

Field name

Initial value

Possible settings

Omission possible

Remarks

Layout

 

File name

 

Windows

Characters (#1)

No

200 bytes or fewer

UNIX

Alphanumeric characters and symbols (#2)

Numeric value byte order

Same as host

Same as host, Big-endian, Little-endian

No

 

Code conversion (#3)

 

Kanji code type

(#4)

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

No

 

Unicode byte order (#5)

Same as host

Same as host, Big-endian, Little-endian

No

 

EBCDIC Set (#6)

EBCDIC kana

EBCDIC kana, EBCDIC lowercase, EBCDIC ASCII, EBCDIC ASPEN, Japan (Latin) for IBM, Japan (Latin) Extended for IBM, NEC katakana, ASCII, Japan (Katakana) Extended for IBM

No

 

#1

:

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

#2

:

The characters < (less than), > (greater than), " (double quotation), ' (single quotation), and & (ampersand) cannot be used in the string.

#3

:

For DataMagic Desktop, this field is displayed but cannot be changed.

#4

:

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

#5

:

This is displayed if UTF-16 is selected as the kanji code.

#6

:

This message is displayed when one of the EBCDIC encodings or JIS is selected for Kanji code type.

 

Table 2.10 Field List for Data Processing Information (Virtual Table Settings/Format = Excel)

Field name

Initial value

Possible settings

Omission possible

Remarks

File name

 

Windows

Characters (#1)

No

200 bytes or fewer

UNIX

Alphanumeric characters and symbols (#2)

Code conversion

 

Kanji code type

UTF-8

Fixed to UTF-8

No

 

#1

:

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

#2

:

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

 

Table 2.11 Field List for Data Processing Information (Virtual Table Settings / Format = Database Table)

Field name

Initial value

Possible settings

Omission possible

Remarks

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

 

Code conversion (#1)

 

Kanji code type

(#2)

SHIFT-JIS、EUC、UTF-16、UTF-8

Yes

 

Unicode byte order (#3)

Same as host

Same as host, Big-endian, Little-endian

Yes

 

#1

:

For DataMagic Desktop grade, this field is displayed but cannot be changed.

#2

:

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

Note that 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) field is used.

#3

:

This is displayed if UTF-16 is selected as the kanji code.

 

Table 2.12 Field List for Data Processing Information (Virtual Table Field Settings)

Field name

Initial value

Possible settings

Omission possible

Remarks

Field name

 

Display only

 

 

Field type

Character string

Character string, Numeric value, Date

No

 

Virtual table field name

 

Characters (#1)

No

255 bytes or fewer

Format = Format

 

No. of occurrences

 

Display only

 

 

Format = Excel

 

Cell/Column

 

Display only

 

 

Format = Database Table

 

Field No.

 

Display only

 

 

Fixed/Variable length

 

Display only

 

 

No. of bytes

 

Display only

 

 

Validity

 

Display only

 

 

#1

:

Only a hyphen (-), underscore (_), and period (.) can be used. Symbols other than these can be entered, but operation is not guaranteed. Note that the following characters cannot be used:

  • Left angle brackets (<), right angle brackets (>), double quotation marks ("), single quotation marks ('), ampersands (&), or commas.

  • DM_REC_COUNT, $VAR, $INUM, $INAME, $DNUM, $DSTR, $MINUM, $RCOUNT, $VDATE

  • External characters or lowercase letters.