16.10 - Dropped 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 are created by the Teradata Database during the execution of a job, and others must be user-created before the job begins. The log table and error table are automatically created by Teradata PT when you run the job script. The error table is dropped during the Cleanup phase if no errors were detected during the job, unless the DropErrorTable attribute is set to No. The log table is dropped after the job completes successfully.

If a job terminates abnormally, then the log and error tables are not dropped. If you want to restart the job from scratch, manually drop these tables by running a BTEQ script.

Care must be taken dropping the target tables manually using a BTEQ script. If something goes wrong with a Stream operator job, and you drop the target table manually and then try to rerun the job, you might lose the original data.