On Tue, 23 Nov 1999, Tom Lane wrote:
> My feeling is that application authors have already decided whether
> they prefer "BEGIN" or "BEGIN TRANSACTION" or "BEGIN WORK", and trying
> to enforce a single standard now is just going to irritate people and
> break existing applications. I vote for leaving well enough alone.
>
> > Bruce, please don't use "begin" and "end" in your book.
>
> Sure, it makes sense for the book to consistently use "BEGIN WORK"
> and "COMMIT WORK", which are probably the least likely to confuse
> novices. But I think actually removing the other variants would be
> just an exercise in causing trouble.
I don't know how Oracle or most everyone else is doing it, but Sybase
uses:
begin transaction [transaction name]
and
commit transaction [transaction name]
I don't see an end transaction in the quick ref, but they do have a:
begin statement block
end
in there.
Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev@michvhf.com flame-mail: /dev/null # include <std/disclaimers.h> Have you
seenhttp://www.pop4.net? Online Campground Directory http://www.camping-usa.com Online Giftshop
Superstore http://www.cloudninegifts.com
==========================================================================
