Error Logging Options - Teradata Database - Teradata Vantage NewSQL Engine

SQL Data Manipulation Language

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
fbo1512081269404.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata Vantage™

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.