Hyperstage may abort a load when invalid values are found. Certain invalid values, however, can be loaded in Hyperstage. The following rules are used with invalid data:
OPTIONS FOR DIFFERENT FORMATS | ||||
---|---|---|---|---|
OPTION |
POSTGRESQL FORMATS TEXT, CSV, BINARY |
TXT_VARIABLE |
IB_BINARY |
HYPERSTAGE |
oids |
As in PostgreSQL |
Not supported |
Not supported |
Not supported |
null |
As in PostgreSQL |
Not supported |
Not supported |
Not supported |
header |
As in PostgreSQL |
Not supported |
Not supported |
Not supported |
force_quote |
As in PostgreSQL |
Not supported |
Not supported |
Not supported |
force_not_null |
As in PostgreSQL |
Not supported |
Not supported |
Not supported |
delimiter |
As in PostgreSQL |
Supported |
Not supported |
Not supported |
quote |
As in PostgreSQL |
Supported |
Not supported |
Not supported |
escape |
As in PostgreSQL |
Supported |
Not supported |
Not supported |
encoding |
As in PostgreSQL |
Supported |
Not supported |
Not supported |
lines_terminated_by |
Not supported |
Supported |
Not supported |
Not supported |
reject_file_path |
Not supported |
Supported |
Not supported |
Not supported |
abort_on_count |
Not supported |
Supported |
Not supported |
Not supported |
abort_on_threshold |
Not supported |
Supported |
Not supported |
Not supported |
pipe_mode |
Not supported |
Supported |
Supported |
Supported |
timeout |
Not supported |
Supported |
Supported |
Supported |
WebFOCUS |