Load operations create a duplication error table that captures errors during job runs. Jobs can use the default names of the error tables, or names can be user-specified as an attribute of the Load operator.
If you specify a name for ErrorTable2, the system creates the table in the default database for the logon user, unless a different database is specified in the WorkingDatabase attribute.
If you do not specify a name for ErrorTable2, the system default name for ErrorTable2 is based on the TargetTable name. The system names the table using the form ttname_UV and creates the table in the database that contains the TargetTable, unless a different database is specified in the WorkingDatabase attribute. This error table is not used when the target table has a non-unique primary index.