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 |