Re: AW: [HACKERS] TRANSACTIONS

Dmitry Samersoff wrote:
> 
> On 23-Feb-2000 Zeugswetter Andreas SB wrote:
> >
> >>  AFAIK, MS Access have no transactions inside it,
> >>  Informix (at least old versions I worked with) always
> >>  perform create,drop, alter object outside transaction
> >>  but IMHO it's not right behavior.
> >
> > MS Access has transactions and Informix (Version 5.00 - 9.20) performs
> > create, drop, alter inside the transaction, same as Oracle and DB2.
     ^^^^^^
 
> 
> OK. May be I miss something.

I don't think so. Not with respect to Oracle. Andreas knows that
Oracle implicitly commits your running transaction -- and starts
a new one whenever a DDL statement is encountered. A large
discussion about this arose about 4 months ago...I can't speak
for DB2.

> 
> --
> Dmitry Samersoff, dms@wplus.net, ICQ:3161705
> http://devnull.wplus.net
> * There will come soft rains ...
> 
> ************