Re: Transaction logs and audit trails - quick overview required

Ian Clark wrote: > > Hi All, > > I've just joined a company who are running an in-house developed > application written in Informix RDS and looking though the code I am > amazed to find that there is no transaction logging going in. > That means no BEGIN WORK, COMMIT WORK or ROLLBACK WORK. > Without these, in a multiuser enviroment I can only forsee problems > but by a freak of nature they seem to be getting along fine! Informix treats each statement as a singleton transaction if no explicit transaction has been started as long as the database is not ANSI mode which begins an implied multi-statement transaction when the first statement outside of a transaction is encountered. Art S. Kagel