Re: Deleting records from a table

Larry: All the following assumes a logged database: If the delete was performed in dbaccess in MENU mode (rather than from the command line mode) then there was an explicit BEGIN WORK; issued by dbaccess before running the SQL in the editor window, so it would have rolled back completely. If it was run in the command line mode then there was no BEGIN WORK; so it would be an implicit single statement transaction and would automatically commit when it completed. But if the user was able to kill the dbaccess session before the delete completed then that would have rolled back as well. So, most likely all is well. If not then the entire table would have been deleted and only rows added since the delete will be in there. So all good or all gone. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Oct 17, 2016 at 11:34 AM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote: > IDS 11.50.FC8 > > Solaris 10 > > If I have a user that logged into Informix and connected to a database via > dbaccess....... > > A user was deleting records from a table using SQL. She forgot to put a > "WHERE" clause in, ran the command, but she hit delete before the command > completed because she saw her mistake. > > Would some of the records have been deleted, or will it treat the command > as a > transaction and do a "rollback"? > > Larry > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a114b31ce352082053f2c8bfd