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 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 the 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