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.
