Previous Topic Next topic Print topic


ON_ERROR

Specifies the automatic response to an error condition resulting from reading a field in a data file. The syntax is:

ON_ERROR = { SKIP | INS_NULL | QUIT | END_ALL};

If ON_ERROR is set to SKIP, a record that contains invalid data is skipped and import goes on to the next record. If ON_ERROR is set to INS_NULL then a null is placed in the field if the field is nullable. If ON_ERROR is set to QUIT, then the Batch Import will be terminated if invalid data is found. If ON_ERROR is set to END_ALL (default), then all Batch Import processing is terminated.

ON_ERROR is an optional Batch Import command.

For example:

ON_ERROR = NULL;

will cause Batch Import to place a null in a field that has caused an error, and to continue with the import despite the error.

Previous Topic Next topic Print topic