When the Update operator encounters a data row that cannot be processed properly, it creates a row in one of the two error tables that are created for each target table in the Update operator job:
These error tables are similar to those used for the Load operator, but the Update error tables are typically named with the following suffixes to distinguish them.
Consider the following facts about error tables:
Errors are separated into two tables, as follows:
The following types of errors are captured:
By default, this error table is assigned a name using the convention:
By default, this error table is assigned a name using the following convention:
Each error table generates eight columns of information that you can use to help determine the cause of the problem. You can specify that the error tables return any or all of these columns, in any order, using an SQL SELECT statement in a BTEQ job.
For details on accessing error tables, see “Accessing and Using Error Tables” on page 160.
In addition, the acquisition error table includes the faulty record, and the application error table includes a mirror image of the target table columns.
Note: Because the application error table includes a mirror image of the target table, preceded by the error information, the target tables for the Update operator job cannot contain column names that are the same as the error table columns, or the Update job terminates and returns a 3861 error message.