16.10 - Auto-Generation of Error Tables - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
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:

  targtable_ET
  targtable_UV