Bad rows
When the system encounters an error processing a row, it
stops analyzing the row, appends the row to the bad rows file, writes
a supporting diagnostic message to the nzlog file
that describes the position and nature of the error, and increments
a rejected rows counter.
String and non-string fields
If an input field corresponds to a column declared as char,
nchar, varchar, or nvarchar, the system considers it a string field.
All other types are considered non-string fields. This distinction
is important because spaces are significant within string fields but
not in non-string fields.
Handle the absence of a value
In SQL, a record must include a value if a column is declared
as not null. When a record contains no value for a column, the column
is considered to be null. The system provides an explicit and implicit
method for conveying nullness.
Load continuation
If you enable load continuation with the allowReplay option,
or set the session variable LOAD_REPLAY_REGION to true, the system
ensures that a simple load that uses external tables continues after
the system is paused and resumed. You do not have to stop and resubmit
the load.