SET IGNORE_IMPORT_ERRORS

Syntax

SET IGNORE_IMPORT_ERRORS;

Description

Use this command in conjunction with IMPORT, REPLACE_DATA or REPLACE_ALL command.

If there is an import error, processing will continue until the end of the input file. Any records that failed to import will be shown in the Data Mover log. If the Data Mover script is run from the command line, the errors will be shown in the output.

Note:

SET IGNORE_IMPORT_ERRORS is only valid in bootstrap mode.

Example

Here is an example to ignore errors when importing import the entire file, when there are errors.

SET INPUT in.dat;
SET IGNORE_IMPORT_ERRORS;
IMPORT *;