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

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? I'm assuming you are using an Informix database server as you posted here (this list doesn't show cross-posting info). Although you don't say which one, the general answer is the same; you can't undo changes committed to the database. All Informix database servers are designed to allow multi-user access, so n users could have already modified the same data you just changed based on your changes. So the concept of an "undo" function becomes impossible. If you think you can implement a satisfactory solution, then you could look at triggers or application code that kept track of changed data and allowed data to be reverted to old versions. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list