Dropped Tables
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.
|
Notice:
|
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.
|