Load Data into an Actian Vector Table Dialog
The Load Data into an Actian Vector Table dialog enables you to load Actian Vector 2.5 or earlier tables with data from a text file. This dialog contains the following pages:
• General
• Advanced Options
• Optional Target Columns
• Optional Date Column Formats
• Output Log
For more information, see Load Data into an Actian Vector Table and vwload Command in the Actian Vector User Guide.
General Page Options
This page contains the following fields:
Load Target Options
This section contains the following fields:
Database Name
Indicates the name of the Actian Vector database
Table Name
Indicates the name of the Actian Vector table to load with data
Basic Options
This section contains the following fields:
Input Data Has a Header Row
Specifies that the input data file contains a header row that should be skipped
Data Delimiter
Specifies the field delimiter to use. The delimiter must be a single character. To use a control character, select Other, and specify an escape sequence. (For more information, see “vwload Escape Sequences” in the Actian Vector User Guide.)
Default: Comma (“,”)
Record Delimiter
Specifies the record delimiter to use. The delimiter must be a single character. To use a control character, select Other, and specify an escape sequence. (For more information, see “vwload Escape Sequences” in the Actian Vector User Guide.)
Default: Line Feed (“\n”)
Input Data File(s)
Specifies the name of the file that contains the data being loaded. You may specify multiple files by entering one per line, pressing Enter to break lines.
If you are connected to an Actian Vector installation on the same host machine where Director is being run, you may open a browse dialog to specify the input file or files by clicking the browse button. This button is disabled for Actian Vector installations on a remote machine.
Advanced Options Page Options
This page contains the following fields:
Quote Character
Specifies the quote character to use. This allows the input to contain quoted strings (for example: "Doe, John", which may contain field or record delimiter characters). To include a quote character in a quoted string, enter it twice. For example: "The ""BIG"" Boss".
The argument must be a single ASCII character or an empty string. If the argument is an empty string, this functionality is disabled.
To use a control character, select Other, and specify an escape sequence. (For more information, see "vwload Escape Sequences" in the Actian Vector User Guide.)
Default: Double Quote (")
Escape Character
Specifies the escape character to use. This enables escaping of single characters to allow a delimiter character to be part of a field (for example: \) or to allow a quote character to be part of a quoted string.
Select one of the possible choices from the list or choose Other to enter the character in the text box to the right.
The argument must be a single ASCII character or an empty string. If the argument is an empty string, this functionality is disabled. To use a control character, select Other, and specify an escape sequence. (For more information, see “vwload Escape Sequences” in the Actian Vector User Guide.)
Default: (none)
Date Format
Sets the date format for the attribute (column). When no attribute is indicated, the value applies to all attributes that are not otherwise set.
Valid values for format are: US, MULTINATIONAL, MULTINATIONAL4, ISO, ISO4, IS09075, SWEDEN, FINLAND, GERMAN, YMD, DMY, MDY, as described in II_DATE_FORMAT in the Ingres SQL Reference Guide.
Default: US
Note: To specify a date format for individual columns, see Optional Date Column Formats Page Options, following.
Null Value
Defines the string that identifies NULL values
Ignore First Field
Ignores the first field in the data file
Ignore Last Field
Ignores the last field in the data file
Character Set
Specifies the input character set. A list of valid character sets can be obtained from the iconv utility on the local system (Linux) and in the Microsoft online documentation (Windows). Some commons ones are: ISO8859-1, LATIN1, UTF8, SHIFT-JIS.
The list button lets you select from one of the Ingres character sets, which are also supported as of Actian Vector 3.0. To specify a character set that is not in the list, choose the Other option (the last one in the list) and enter the character set name in the text field to the right.
Default: Current
Lines to Skip
Specifies the number of lines (records) to skip
Default: 0
Log File
Specifies the name of a log file where failed records are logged
Rollback
Rolls back on error
Error Count
Loading terminates after the number of errors specified
Default: 100
Verbose Output
Prints a verbose progress report
Optional Target Columns Page Options
This page contains the following fields:
All Columns
Specifies that data from all columns should be loaded into the Actian Vector table
Specify Columns
Lets you specify particular columns to load into the Actian Vector table
Optional Date Column Formats Page Options
This page contains a table that lets you specify date formats for selected columns. The table contains the following fields:
Column
Specifies one or more date/time columns for which you want to specify formats
Data Type
Specifies a date/time data type. For more information, see the date/time class in “Data Types” in the Actian Vector SQL Language Guide.
Input Date Format
Specifies a unique format for the selected column. For a list of format specifiers, see the DATE_FORMAT function in “Date and Time Functions” in the Actian Vector SQL Language Guide.
Output Log Page Options
The Output Log page displays the output of the process based on the options you have selected on the other dialog pages.