17.10 - INSERT SELECT and Error Logging Tables - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Temporal Table Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1182-171K
Language
English (United States)

You can create an error logging table that you associate with a temporal table when you want Vantage to log information about insert errors that occur during an INSERT SELECT operation on the temporal table.

To create an error logging table, use the CREATE ERROR TABLE statement. Error logging tables are nontemporal tables. When you create an error logging table that you associate with a temporal table, the temporal columns in the temporal table are included in the error logging table as regular period data type columns.

If the temporal table uses derived period columns for the temporal columns, the corresponding columns in the error table will also be derived period columns.

To enable error logging for an INSERT SELECT statement, specify the LOGGING ERRORS option. The behavior of the error logging facilities for INSERT SELECT errors is the same for nontemporal and temporal tables.

For details on how to create an error logging table, see the CREATE ERROR TABLE statement in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144. For details on how to specify error handling for the INSERT SELECT statement, see Teradata Vantage™ - SQL Data Manipulation Language, B035-1146.