What is the best way to roll back a long sequence of transactions?

Posted in 2003

Steve Kurlande — 25 Jun 2003 01:50:48 -0700 — source: Usenet: comp.databases.informix

Hi, Let's assume I've been making thousands of inserts, deletes, and updates to a table and find that there is an error in the data, and would like to undo these inserts, deletes, and updates. What is the procedure for the best way to do this? Is there anything I should do beforehand to make this easier? Thank you, Steven Kurlander

↪ replying to Steve Kurlande

The Big Potatoe — Wed, 25 Jun 2003 13:23:03 +0100 — source: Usenet: comp.databases.informix

Steve Kurlande wrote: > Hi, > > Let's assume I've been making thousands of inserts, deletes, and updates to > a table and find that there is an error in the data, and would like to > undo these inserts, deletes, and updates. > > What is the procedure for the best way to do this? Is there anything > I should do beforehand to make this easier? > > Thank you, > Steven Kurlander Humm, I don't think you mean "transactions" in the subject - do you? This is normally what a transaction (singular) is for. So, begin work; thousands of inserts, deletes, and updates to a table; rollback work; But ... what are you actually doing? "Please peel me gently"