Suppose I am loading a file of 100 records and it fails at 82nd record due to data type mismatch. Will the rest of the 81 records be roll backed?What will be my restartability strategy?
Solved! Go to Solution.
It depends. In Teradata mode, by default each INSERT will be an implicit, auto-committed transaction. But if you explicitly BEGIN TRANSACTION prior to the INSERTs, then they would all be rolled back when an error occurs.
In ANSI mode, the INSERTs will be part of one implicit transaction, and the script can choose to COMMIT or ROLLBACK in case of an error.
And if you are using multiple sessions, that's another layer of complexity - since sessions are independent of each other.
Thanks for your reply.
So if I am using TD mode and the records are auto committed ,then how do I restart? How do I delete and restart if the table is not empty?What I want to know is does bteq have any checkpoint or log table from where I can start again.