<REFENTRY ID="SQL-COMMIT"> <REFMETA> <REFENTRYTITLE> COMMIT </REFENTRYTITLE> <REFMISCINFO>SQL - Language Statements</REFMISCINFO> </REFMETA> <REFNAMEDIV> <REFNAME> COMMIT </REFNAME> <REFPURPOSE> Commits the current transaction </REFPURPOSE> <REFSYNOPSISDIV> <REFSYNOPSISDIVINFO> <DATE>1998-04-15</DATE> </REFSYNOPSISDIVINFO> <SYNOPSIS> COMMIT [ WORK ] </SYNOPSIS> <REFSECT2 ID="R2-SQL-COMMIT-1"> <REFSECT2INFO> <DATE>1998-04-15</DATE> </REFSECT2INFO> <TITLE> Inputs </TITLE> <PARA> </PARA> <VARIABLELIST> <VARLISTENTRY> <TERM> </TERM> <LISTITEM> <PARA> <VARIABLELIST> <VARLISTENTRY> <TERM> <ReturnValue>None</ReturnValue> </TERM> <LISTITEM> <PARA> </PARA> </LISTITEM> </VARLISTENTRY> </variablelist> </LISTITEM> </VARLISTENTRY> </VARIABLELIST> </REFSECT2> <REFSECT2 ID="R2-SQL-COMMIT-2"> <REFSECT2INFO> <DATE>1998-04-15</DATE> </REFSECT2INFO> <TITLE> Outputs </TITLE> <PARA> </PARA> <VARIABLELIST> <VARLISTENTRY> <TERM> </TERM> <LISTITEM> <PARA> <VARIABLELIST> <VARLISTENTRY> <TERM> <ReturnValue>END</ReturnValue> </TERM> <LISTITEM> <PARA> Message returned if the transaction is successfully committed. </PARA> </LISTITEM> </VARLISTENTRY> <VARLISTENTRY> <TERM> <ReturnValue>NOTICE EndTransactionBlock and not inprogress/abort state </ReturnValue> </TERM> <LISTITEM> <PARA> If there is no transaction in progress. </PARA> </LISTITEM> </VARLISTENTRY> </variablelist> </LISTITEM> </VARLISTENTRY> </VARIABLELIST> </REFSECT2> </REFSYNOPSISDIV> <REFSECT1 ID="R1-SQL-COMMIT-1"> <REFSECT1INFO> <DATE>1998-04-15</DATE> </REFSECT1INFO> <TITLE> Description </TITLE> <PARA> COMMIT commits the current transaction. All changes made by the transaction become visible to others and are guaranteed to be durable if a crash occurs. </PARA> <REFSECT2 ID="R2-SQL-COMMIT-3"> <REFSECT2INFO> <DATE>1998-04-15</DATE> </REFSECT2INFO> <TITLE> Notes </TITLE> <PARA> The keyword WORK is noise and can be omitted. </PARA> <para> Refer to ROLLBACK statements to abort a transaction. </para> </REFSECT2> </refsect1> <REFSECT1 ID="R1-SQL-COMMIT-2"> <TITLE> Usage </TITLE> <PARA> To make all changes permanent: </PARA> <ProgramListing> COMMIT WORK; </ProgramListing> </REFSECT1> <REFSECT1 ID="R1-SQL-COMMIT-3"> <TITLE> Compatibility </TITLE> <PARA> </PARA> <REFSECT2 ID="R2-SQL-COMMIT-4"> <REFSECT2INFO> <DATE>1998-04-15</DATE> </REFSECT2INFO> <TITLE> SQL92 </TITLE> <PARA> Full compatibility. </PARA> </refsect2> </refsect1> </REFENTRY> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t sgml-parent-document:nil sgml-default-dtd-file:"../reference.ced" sgml-exposed-tags:nil sgml-local-catalogs:"/usr/lib/sgml/catalog" sgml-local-ecat-files:nil End: -->