Path: utzoo!utgpu!jarvis.csri.toronto.edu!rutgers!mit-eddie!uw-beaver!tektronix!sequent!john
From: john@sequent.UUCP (John Vander Borght)
Newsgroups: comp.databases
Subject: Re: SQL Standardization
Keywords: module language, implicit commit
Message-ID: <16856@sequent.UUCP>
Date: 2 Jun 89 23:17:10 GMT
References: <1120@ethz.UUCP>
Reply-To: john@sequent.UUCP (John Vander Borght)
Organization: Sequent Computer Systems, Inc
Lines: 23


>From: marti@ethz.UUCP (Robert Marti)
> ...
>  Is any vendor out there
>  willing to state which operations do implicit commits in their
>  current implementations?
> ...

Oracle states in the SQL*Plus Reference Guide Version 2.0 on page 2-33 (Commit)

"The following commands also commit changes to the database:
ALTER, AUDIT, COMMENT, CONNECT, CREATE, DISCONNECT, DROP, EXIT, GRANT, NOAUDIT,
QUIT, REVOKE, and RENAME."

I would assume that most if not all of these also commit in embedded-SQL.
-----------------------------------------------------------------------------
"Mind over matter excludes golf balls." - Fred Corcoran

"If you are shooting under 80 you are neglecting your business; over 80
you are neglecting your golf." - Walter Hagen

John Vander Borght, System Analyst
[ogcvax,tektronix,pur-ee,ut-sally,decwrl]!sequent!john