Merge with error table

Database
Enthusiast

Merge with error table

Hi,

Recently I came to know below feature of Merge.

LOGGING ALL ERRORS WITH NO LIMIT

But I found after the error table created the show Select * of error table is not referring the base table. And also I cannot drop the base table before dropping the error table.

Is there any way where one can find what is the error table created for a base table?

Also what will be the effect of logging errors with limit? Is there any document that can provide more knowledge about this feature?

Tags (1)
1 REPLY
Senior Apprentice

Re: Merge with error table

Hi Moutusi,

dbc.ErrorTblsV tracks existing error tables.

And when you read the manuals you'll find all details:

The SQL DML manual for MERGE and the SQL DDL manuals for CREATE ERROR TABLE.

As a customer you might also have access to the Teradata 12.0 SQL Bulk Loading Complex Error Handling User’s Guide Orange Book.