Importing Files With Invalid Values

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:

If a numeric value is invalid, the value is replaced by 0.
If a TIME, DATE, or TIMESTAMP is invalid, the value is replaced with a minimum value for the given data type.
If a NULL value is imported into a column defined as NOT NULL (except for TIMESTAMP columns), it is replaced by 0 (for numerical, date, and time columns) or by an empty string (for string columns).

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