Re: Rolling back transactions

Ah, excellent idea! Just what I was looking for. Thanks! Uday Nils Myklebust wrote: } } uday@dpg.rnb.com (Uday Shankar) wrote: } } :Ok, thanks. I was wondering if there was a way around this, since } :we typically do our testing in unlogged databases. I guess there } :really isn't a way to roll back unlogged transactions then, but } :I thought I'd ask anyway! } } In this case it might be usefull to turn on logging but use /dev/null } as the tape device. In that case you have logging and can do } begin/commit/rollback, but you can do no recovery of the logs. That } may be usefull for testing purposes. } } Nils.Myklebust@idg.no } NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway } My opinions are those of my company } The Informix FAQ is at http://www.iiug.org -- Uday Shankar Derivative Products Group Republic National Bank of New York uday@dpg.rnb.com (212) 525-8000