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

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.10

Published

July 2021

Language

English (United States)

Last Update

2021-07-27

dita:mapPath

imq1591724555718.ditamap

dita:ditavalPath

imq1591724555718.ditaval

dita:id

B035-1184

lifecycle

Product Category

Teradata Vantage™

By default, the maximum number of errors to log is 10. To change the maximum number, use the SET QUERY_BAND statement with the ForeignTableErrorsLimit field. For information about SET QUERY_BAND, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144. For information about ForeignTableErrorsLimit, see Teradata Vantage™ - Database Utilities, B035-1102.