Following are the error logging options you can specify for tables that have an associated error table. See “CREATE ERROR TABLE” in
Teradata Vantage™ SQL Data Definition Language Syntax and Examples, B035-1144
.
- LOGGING ERRORS
- LOGGING ALL ERRORS
- 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:
- If the current session mode is ANSI, the erring request aborts and rolls back.
- If the current session mode is Teradata, the erring transaction aborts and rolls back.
- 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
- 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
- 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.