Specifies list of attributes (columns) to load. An empty attr name indicates an input field that is to be ignored.

Default: All attributes are loaded if no ‑‑attributes argument is specified.

Turns roll back on error on or off. If set to off, the load transaction will not be rolled back when errors were encountered, causing partial data to be loaded.

Default: on

Speeds up loading by parallelizing some of the processing steps.

For requirements, restrictions, and changes in behavior when using this option, see vwload in Parallel Mode.

Specifies the input character. See vwload Supported Character Sets.

Default: no conversion

Sets date or timestamp 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 described in vwload Date Format Settings.

Alternatively, a custom format string can be specified by starting the format with a '+' sign followed by the format string. The format string can consist of any of the format specifier characters used on the DATE_FORMAT function.

To be able to use any character in the format string (including for example, "," and "="), you must quote the format string in the same way that you would quote a delimited identifier on the command line (for example: 'ColX="+%M,%Y,%d",ColY=US').

Default: US

Examples:

Specifies the escape character to use. This allows 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.

The argument must be a single ASCII character or an empty string. If the argument is an empty string, this functionality is disabled. To specify a control character, use an escape sequence (see vwload Escape Sequences).

Default: none

Interprets data escape sequences as generated by MySQL and PostgreSQL. This also allows setting \N as the NULL representation.

Specifies field delimiter to use. The delimiter must be a single character. To specify a control character, use an escape sequence (see vwload Escape Sequences).

Default: "|"

Sets the frequency of verbose progress reports, in number of records. Optionally append one of k K m M g G as magnitude multiplier. For example: 5M means print a report every 5 million records.

Skips header line in files.

Displays syntax information.

Ignores the first field.

Ignores the last field.

Logs rejected rows and corresponding errors to the specified file. The file is created by vwload.

When used with the ‑‑cluster option, specify a directory name instead of a file name. For details, see vwload in Parallel Mode.

Enables timing information. Timing statistics will be printed at the end. In verbose mode, they will be printed for every progress update.

Defines the string that identifies NULL values.

Default: ""

By default, an empty string is treated as a null unless -n option is used. For example, suppose the following contents in data file a1.csv:

1|\n|
2|a|b
3||c

If we use vwload -t t1 -n '\n' a1.csv, then 3rd row, 2nd column will have an empty string and not null; 1st row, 2nd column \n will be loaded as null as defined in -n flag.

If we use vwload -t t1 a1.csv (without -n), then 3rd row, 2nd column will be loaded as null; 1st row, 2nd column will be loaded as '\n'.

Uses strict NULL value checking. This distinguishes between plain and quoted or escaped occurrences of a NULL representation. For example, NULL is a NULL value, whereas "NULL" is a 4-character string value. By default, vwload does not make this distinction. This option allows proper loading of some data generated by MySQL and PostgreSQL.

When –nullvalue is used, data may contain spaces in front of the null identifiers. This option applies to non-character columns only. For example, if --nullvalue NADA is specified, –nonchar_leading_spaces_null will interpret a DATE column containing “NADA” or “ NADA” as NULL.

Keeps empty strings. Does not consider the input value NULL if it is empty (that is, contains two consecutive field delimiters). For VARCHAR, the value becomes an empty string; for CHAR the value becomes blanks. This option applies only to CHAR, NCHAR, VARCHAR, and NVARCHAR columns that are NOT NULL.

Specifies the user password, not valid when using DBMS authentication.

Default: Prompts on TTY when needed.

Specifies the quote character(s) to use. This allows the input to contain quoted fields (for example "Doe, John"), which may contain field or record delimiter characters. To include a quote character inside a quoted field, enter it twice in the input--for example: "The ""BIG"" Boss". When using distinct open and close quote characters, enter only the close quote character twice--for example: [The [BIG]] Boss].

The argument must be one or two ASCII characters or an empty string.

If the argument is an empty string, this functionality is disabled. If the argument is two characters, the first character is used as the opening quote character, and the second as the closing quote character. For example, specify "[]" to allow [quoted string].

To specify a control character, use an escape sequence (see vwload Escape Sequences).

Default: none

Specifies record delimiter to use. The delimiter must be a single character. To specify a control character, use an escape sequence (see vwload Escape Sequences).

Default: "\n"

Inserts data through the PDT (in-memory) updates, rather than directly appending the data in bulk to the table's data blocks on disk. This allows concurrent inserts, at the cost of decreased performance at high bulk volume, increased memory consumption. At the time of the load, the whole volume of loaded data will have to fit in memory, and only later it will be propagated to the table's blocks on disk through update propagation.

Specifies the number of records to skip.

Default: 0

Substitutes the specified character for any invalid input character during character set conversion. When no substitute character is provided, an invalid input character is considered an error condition. Specifying a substitute character allows records that contain invalid characters to be loaded successfully.

The argument must be a single Unicode character or an empty string. If the argument is an empty string, the functionality is disabled.

To specify a control character or Unicode code point that cannot easily be typed on the keyboard, use an escape sequence.

Opens input files in text mode and does not perform newline conversion. On Linux, this may gain a 5 to 10 percent performance improvement. On Windows, there is no known advantage to using this option. (By default, vwload opens files in binary mode and performs automatic newline conversion, transparently handling text formats of various operating systems.)

Specifies the effective user for the session.

Specifies the user name and password used for DBMS_authentication.

Prints progress report.

Terminates after n errors.

When used with the ‑‑cluster option, terminates after the first n errors in all input files. For details, see vwload in Parallel Mode.

Default: 0 (do not terminate)

Creates statistics for the table. Builds histograms for all columns of the loaded table.

Detects GZ and ZIP files. Compressed files are automatically detected by the file contents, not by the file suffix. If you are loading from a directory or using a file name wildcard, you can mix regular text files, GZ, and ZIP.