Re: Transaction logging in SE

Stuart Hemming (shemminga@cix.compulink.co.uk) wrote: : I use an app for manufacturing control which until very recently didn't : support transactions. The autthors are now saying that they only support : TL in Online implementations as TL in SE doesn't work. Given that this : app is designed to work only with >v4 engines and tools would anyone care : to comment on this statement. OnLine and SE both support transactions but there are differences. SE does *not* support: - rollback of DDL statements (although they are logged and rollforward will use them) - shared (read-only) locks, so SET ISOLATION is not available on SE Can anyone think of other differences (besides DBA stuff like tbtape)? Maybe their product depends on some of these features. -- Jeff Sturm jsturm@mail.msen.com