Error Logging Tables - Teradata Vantage

You can create an error logging table that you associate with a permanent base table when you want Vantage to log information about the following:

Insert errors that occur during an SQL INSERT ... SELECT operation on the permanent base table
Update and insert errors that occur during an SQL MERGE operation on the permanent base table

To enable error logging for an INSERT ... SELECT or MERGE statement, specify the LOGGING ERRORS option.

Error on MERGE or INSERT … SELECT	What Request Does	Error Logging Table Contents
Handleable by error logging facilities	Completes	Error row for each error. Marker row to use to determine number of error rows for request.
Handleable by error logging facilities	Ends and rolls back when referential integrity (RI) or unique secondary index (USI) violations are detected during index maintenance	Error row for each USI or RI violation. Error row for each error detected before index maintenance.
Reach error limit specified by LOGGING ERRORS	Ends and rolls back	Error row for each error, including error that caused limit to be reached.
Not handleable by error logging facilities	Ends and rolls back	Error row for each error until error that error logging facilities could not handle.

You can use the information in the error logging table to determine how to recover from the errors, such as which data rows to delete or correct and whether to rerun the request.