Virtual table settings

This section explains the fields of the virtual table settings. You can specify a maximum of 20 virtual tables.

(1) Main fields

Format

File format set as a virtual table. The screen will change depending on the selection.

CSV

: CSV data

Format

: Format data

Excel

: Excel format

Database Table

: Database table data

Comments

Comment about the virtual table settings file to be set

(2) Fields for files

ID

CSV

FMT

Excel

DB

ID for identifying the file.

Specify the CSV ID, Format ID, Excel ID, or Database table ID depending on Format.

If Format is not CSV, make sure that you specify this field.

Omit ID

CSV

Specify this if you do not wish to set a CSV ID. You can omit ID. If you select this, Delimiter and Enclosure character are active.

Delimiter

CSV

The delimiter for each field of the CSV format file.

Specify from the pull down list.

You can specify it when you select Omit ID.

Delimiter (hexadecimal)

CSV

If Enter hexadecimal value is selected for Delimiter, specify a delimiter. Enter the value by using hexadecimal characters.

Enclosure character

CSV

The enclosure character for character data in the CSV format file.

Specify from the pull down list.

You can specify it when you select Omit ID.

Note

If Enclosure character is not specified, all input fields are treated as character data.

Enclosure character (hexadecimal)

CSV

If Enter hexadecimal value is selected for Enclosure character, specify an enclosure character. Enter the value by using hexadecimal characters.

File name

CSV

FMT

Excel

File name acquired as a virtual table.

Specify the virtual table file name with an absolute path or relative path.

The same file as an output file, standard input $STDIN, and standard output $STDOUT cannot be specified. If you specify any of these, upon execution, an error occurs.

Use header record

CSV

Select to skip from title row to specified row in the file set as a virtual table without treating them as data or not.

Record number

CSV

Specify the number of records to skip when Use header record is set to ON. If the title row is 1, you can specify a maximum of 99 records.

Numeric value byte order

FMT

DB

The numeric value byte order for virtual table.

This field is enabled only if Field type is B or F. Select from Same as host, Big-endian, or Little-endian.

Handling of null values in numeric fields

DB

How null values in numeric fields are handled.

Select whether to handle a null in the data as a null or to replace the null with a 0.

Zero (0)

: Null will be handled as 0 of type Z.

Null

: Null will be handled as Null of type M.

(3) Code conversion fields

Kanji code type

CSV

FMT

Excel

DB

The kanji code type of data specified as file name.Select from Shift JIS, JEF, EUC, IBM kanji, KEIS, NEC kanji, UTF-8, UTF-16, or JIS. If CSV or Database Table is selected for Format in the virtual table, specify ShiftJIS, EUC, UTF-8, or UTF-16.Only UTF-8 can be specified for Excel.

= Remarks =

In the case of DataMagic Desktop grade, this field cannot be specified.

Note

If the data to be stored contains an external character, the external character is converted to the default code.

Unicode byte order

CSV

FMT

DB

The UTF-16 byte order.

If UTF-16 is selected for Kanji code type for the virtual table, specify the byte order of the virtual table.

Same as host

: Depends on the byte order of the connected hardware (Windows or UNIX).

Big-endian

: Utilizes Big-endian.

Little-endian

: Utilizes Little-endian.

= Remarks =

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

Line break code

CSV

Specify the line break code by using a hexadecimal value.

Up to specified line break code will be determined as a record.

If Kanji code type is UTF-16, enter this value as either 4 bytes or 8 bytes. If Kanji code type is anything other than UTF-16, enter this value as either 2 bytes or 4 bytes.

EBCDIC set

FMT

The 1-byte code set type.

If Kanji code type for file name is an EBCDIC type or JIS code, specify this field. The code set types that you can specify are as follows.

Table 2.38 1-Byte Code Set Type for Virtual Table File (EBCDIC Type, JIS)

EBCDIC type

JIS

EBCDIC kana

EBCDIC lowercase

EBCDIC ASCII

EBCDIC ASPEN

Japan (Latin) for IBM

Japan (Latin) Extended for IBM

NEC Katakana

Japan (Katakana) Extended for IBM

 

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
= Remarks =

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

Note

This is enabled if the Input kanji code type is an EBCDIC type (JEF, IBM kanji, KEIS, NEC kanji) and if EBCDIC set for the output settings is anything other than User table 1 through User table 3.

(4) Field for Virtual table information

Virtual table name

CSV

FMT

Excel

DB

Set the virtual table name used for data processing.

Field list

Format

CSV

FMT

Excel

DB

Clicking the Import Fields button displays the same format as the settings for the main field.

ID

CSV

FMT

Excel

DB

Clicking the Import Fields button displays the ID set for ID in the virtual table settings.

Field No.

CSV

FMT

Excel

DB

A serial number from 1 up to the displayed rows will be assigned from the top.

Cell/Column

Excel

Specifies a cell of an Excel file or a column of a table.

Validity

CSV

FMT

Excel

DB

Specifies to use as a virtual table field or not. If the check box is selected, it will be enabled as a field.

Field Name

CSV

FMT

Excel

DB
If the format is CSV, Format, Excel, or Database Table

Clicking the Import Fields button displays the field list for the specified ID.

Use the check box to select the field to be set in the virtual table.

If the format is CSV and you omit the ID

Clicking the Import Fields button displays the Additional Field Settings screen and displays a serial number from 1 to the displayed rows from the top.

No. of occurrences

FMT

Clicking the Import Fields button displays the occurrences number for the field that was set with the specified ID.

Fixed/Variable length

DB

Clicking the Import Fields displays the setting value for the Fixed/Variable length for the field that was set with the specified ID.

No. of bytes

DB

Clicking the Import Fields displays the number of bytes for the set field in the specified ID.

Field type

CSV

FMT

Excel

DB

Select the attribute of the field to be set on the virtual table from Character string, Numeric value, Date, and Binary. If CSV is selected for Format in the virtual table, you cannot select Binary.

Virtual table field name

CSV

FMT

Excel

DB

Displays the field name of the field to be set on virtual table. A maximum of 998 fields can be set.

(5) Virtual table field settings fields

Specify the field to be set on the virtual table.

Field name

CSV

FMT

Excel

DB

Displays the virtual table field name to be set.

Cell/Column

Excel

Specifies a cell of an Excel file or a column of a table. This field is displayed only if Excel is selected for Format in the virtual table settings. You cannot edit the value.

Field type

CSV

FMT

Excel

DB

Select the attribute of the field to be set on the virtual table from Character string, Numeric value, Date, or Binary. However, if CSV is set for Format in virtual table settings, you cannot select Binary.

Virtual table field name

CSV

FMT

Excel

DB

Set the field name of the field to be set on virtual table.

No. of occurrences

FMT

Displays the occurrences number of the field that is set.

Fixed/Variable length

DB

Displays the content that is set.

No. of bytes

DB

Displays the content that is set.

Note

If the conversion process finishes normally, the virtual table is automatically deleted. However, if the process does not finish normally due to a crash or another reason, the virtual table might not be deleted. In such a case, delete the following file from the folder set as work file directory name (work_dir) in the system environment settings file (huledenv.conf).

[uuid].vttable.tmp

[uuid].vttable.tmp-journal

[uuid]： Unique identification character string