is this possible.I think as Update creates a Table level locking this scenario is not possible.
Please provide your valuable thoughts.
Thanks in Advance !!!
As you know that Update Operator uses table level locks, it is not possible for an update operator to load the same table concurrently.
further when the apply statement starts the both update instances will try to get lock on the same table and the script will result in a failure!
Cant we handle this by setting up SLEEP and TENACITY interval when we run.
Yes. That will be one way of queuing up jobs using the Update operator when multiple jobs want to target the same table.
(I was assuming the original question implied you wanted to jobs at the same time to load the same table, which cannot be done.)
Is it possible to execute a 'Delete standalone' using update operator and another Update in the same TPT job
('Delete from tablex where col1 > 123;')
I believe Teradata is giving you the answer. :)
Teradata locks the table while these operations are taking place.
So, the answer is no. You cannot have 2 TPT jobs using the MultiLoad protocol accessing the same table at the same time.