Re: SET TRANSACTION question

MarkDenham@aol.com wrote: > > Peter > > I do not have experience of the set transaction statement, but I do know that > if you > use SET ISOLATION, its effect lasts until you next explicitly change the > isolation. > SET ISOLATION has always worked in this way.> > I would assume that SET TRANSACTION is working in the same fashion. > > I would also suspect that the behaviour you refer to is only in operation > when the > database is created as MODE ANSI, but this is just a wild guess. > > Mark > MarkDenham@aol.com (home) > Denham.M@amstr.com (work) >> '... after >>a COMMIT WORK statement completes the transaction or a ROLLBACK WORK >>statement cancels the transaction, the isolation level is reset to >>the default.' I am not sure where the quoted statement comes from. However, I do know both SET ISOLATION and SET TRANSACTION work the same way -- the new isolation level will stay in effect until it is explicitely changed. Even with ANSI compliant database, there is no such "reset" function. Chao Y. Din