Hi, ALL,
I am trying to execute a huge script (~40K lines) that will populate
my database.
The script starts with "BEGIN TRANSACTION" and will end
with "COMMIT".
however I'd like to rollback if there is an error encounter.
When I execute it from the Terminal I do use
-v ON_ERROR_STOP=1
but I'd like to rolback the transaction so it starts a fresh every time.
Is there some kind of
ON ERROR ROLLBACK
command I can put inside the script?
Thank you.