All Forums Database
Moutusi 38 posts Joined 03/13
27 Sep 2014
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?

Thanks, Moutusi
Tags:
dnoeth 4628 posts Joined 11/04
27 Sep 2014

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.

Dieter

You must sign in to leave a comment.