Limits and Function of Error Tables | CREATE ERROR TABLE | Teradata Vantage - Error Logging Limits - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
jpx1556733107962.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1184
lifecycle
previous
Product Category
Teradata Vantage™

You can specify a WITH LIMIT OF error_limit clause in an INSERT … SELECT or MERGE request with a value in the range of 1 to 16,000,000, inclusive. This limit is based on the largest number a system semaphore counter can support.

If you do not specify a WITH LIMIT OF clause, the request uses the default error limit of 10.

You can also specify a WITH NO LIMIT clause if you do not want to specify an error limit.

If the INSERT … SELECT or MERGE request accumulates the number of errors in the specified error limit, the request or transaction aborts in ANSI or Teradata mode, respectively, and all changes to the target table rows are rolled back.

The database preserves any error table rows previously logged by the aborted request or transaction and does not roll them back.

See “INSERT/INSERT … SELECT” and “MERGE” in Teradata Vantage™ - SQL Data Manipulation Language, B035-1146 for details.