The DecimalDelim option
Specifies the decimal delimiter for the following data
types: float, double, numeric, time, timetz, and timestamp. This format
supports both text-delimited and fixed-length formats. The default
is '.'.
The encoding option
The system supports single-byte characters in Latin9 encoding,
and Unicode data in the multi-byte UTF-8 encoding. Use the encoding option
to specify the type of data in the file.
The FillRecord option
Specifies whether to allow an input line with fewer columns
than the table definition. Missing or trailing input fields must be
treated as nulls if the columns are nullable. The default is false.
The Format option
Specifies the data format of the source file to load and
unload.
The IgnoreZero option
Specifies discarding byte value zero in char() and varchar()
fields.
The Layout option
Specifies the location of fields of the input record. The
format is a series of comma-separated zone definitions within braces.
The LogDir option
Specifies the directory to which nzlog and nzbad files
are generated for loads. This option is not used for unloads.
The MaxErrors option
Specifies the number of errors at which the system stops
processing rows. If the count of rejected rows reaches this threshold,
the system immediately ends and rolls back the load.
The MaxRows options
Specifies to stop processing after this initial number
of rows. Use a limit clause with the SELECT statement to limit loading
data. The default is 0 (load all rows).
The NullValue option
Specifies the string to use for the null value, with a
maximum 4-byte UTF-8 string. The default is ‘NULL’.
The QuotedValue option
Specifies whether data values are quoted or not. The default
is false.
The RecordDelim option
Specifies that the row/record delimiter to be used is the
string literal.
The RecordLength option
Specifies the length of the entire record. Includes the
length itself, but does not include the RecordDelimiter.
The RemoteSource option
Specifies the source data file is remote, and takes the
following values: ODBC, JDBC, OLE-DB, or the empty string.
The SkipRows option
Specifies the number of initial rows to skip before loading
the data.
The SocketBufSize option
Specifies the chunk size at which to read the data from
the source file, expressed in bytes.
The TimeDelim option
Specifies the single-byte character that separates the
time components. The default is a colon character ':'.
The TimeRoundNanos option
Rounds the time value to six fractional seconds digits.
You can use the timeRoundNanos option to specify
that the system will allow and round non-zero digits with smaller
than microsecond precision.
The TimeStyle option
Specifies the time format ('24HOUR', '12HOUR') used in
the data file. The default is '24HOUR'.
The TruncString option
Specifies how to process strings that are longer than their
declared storage.
The Y2Base option
If you specify the Y2-style date, use the -y2Base option
to specify the start of the 100-year range.