Error Logging Options
Following are the error logging options you can specify for tables that have an associated error table. See “CREATE ERROR TABLE” in SQL Data Definition Language.
Syntax Element … |
Specifies … |
LOGGING ERRORS LOGGING ALL ERRORS |
to log all data errors, reference index errors, and USI errors. If you do not specify the LOGGING ERRORS option, the system does not provide error handling. If an error occurs, the following session‑mode behavior occurs: In certain cases, such as a deadlock, the erring transaction roles back. The optional keyword ALL is the default. If you log errors, then you must log all errors. |
WITH NO LIMIT |
that there is no limit to the number of errors that can be logged in the error table associated with the target data table for this INSERT … SELECT load operation. Errors are logged up to the system-determined limit of 16,000,000 errors. |
WITH LIMIT OF error_limit |
that the limit on the number of errors that can be logged in the error table associated with the target data table for this INSERT … SELECT load operation is error_limit, The value you specify for error_limit can be from 1 through 16,000,000,. If you do not specify a value for the LIMIT option, the system defaults to a 10 error limit. |