17.00 - Dropping Tables During a Load - Parallel Transporter

Teradata® Parallel Transporter Application Programming Interface Programmer Guide

prodname
Parallel Transporter
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2516-220K

Some tables are created by the database during the execution of a job, and others must be created by the user before the job begins. When a job is run, the log table and error table are created automatically. The error table is dropped during the Cleanup phase if no errors were detected during the job. 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, you need to manually drop these tables by running a BTEQ script to drop and recreate the tables.

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