hi all,
i am using TPUMP stage to load the teradata table.. whenever the jobs get aborted because of some error after rectifing the error if i rerun the job without clearing the contents of the log table whcih is created by TPUMP stage it will abort the job by throwing the following error ' log table already exist' ,when i clear the log table job will run successfully..
may i know why this is happening?
should datastage expects the log table to be empty to rerun the aborted job?
or is there are any solutions to append the log tabel to rerun the aborted job?
related to log table in TPUMP Stage
Moderators: chulett, rschirm, roy
related to log table in TPUMP Stage
regards,
Rakesh
Rakesh
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
ray.wurlod wrote:The Teradata TPUMP utility expects the log table to be empty. It's not a DataStage requirement. ...
thank you...
is there is anyways to overcome this clearing statement.....
what i mean to say is, inside TPUMP utility i am writing "delete from log_tablename", but few not agree for this.. is there any way...
regards,
Rakesh
Rakesh
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: