16.10 - Auto-Generation of Error Tables - Parallel Transporter

Teradata Parallel Transporter Reference

Parallel Transporter
Release Number
July 2017
Content Type
Programming Reference
Publication ID
English (United States)

Some tables must be created by the user before the job begins and some are created during the execution of a job. A target table must exist on the Teradata Database when the Load operator job is executed.

If you have not specified error tables (specifying them is optional), the Load operator automatically creates names of the error tables as follows:

  • The first error table is ttname__ET
  • The second error table is ttname_UV

where ttname is the name of the corresponding target table.

The value of the TargetTable attribute is truncated to the maximum number of characters for object names that Teradata Database supports, minus 3 characters before the suffixes "_ET" and "_UV" are appended to target table names. This means that if the value of the TargetTable attribute is a fully qualified table name and that fully qualified name exceeds the maximum supported length of a database object, the generated names for the error tables may not be what you intend. In such a situation, Teradata recommends that you provide the names of the error tables and not rely on the Load operator to generate the names for these tables automatically.

For example, if the following is specified when no error table specifications exist,

  VARCHAR TargetTable = 'ttname’

the Load operator creates the following error tables: