commit.sgml
上传用户:blenddy
上传日期:2007-01-07
资源大小:6495k
文件大小:3k
源码类别:

数据库系统

开发平台:

Unix_Linux

  1. <refentry id="SQL-COMMIT">
  2.  <refmeta>
  3.   <refentrytitle id="SQL-COMMIT-TITLE">
  4.    COMMIT
  5.   </refentrytitle>
  6.   <refmiscinfo>SQL - Language Statements</refmiscinfo>
  7.  </refmeta>
  8.  <refnamediv>
  9.   <refname>
  10.    COMMIT
  11.   </refname>
  12.   <refpurpose>
  13.    Commits the current transaction
  14.   </refpurpose>
  15.  </refnamediv>  
  16.   
  17.  <refsynopsisdiv>
  18.   <refsynopsisdivinfo>
  19.    <date>1998-09-08</date>
  20.   </refsynopsisdivinfo>
  21.   <synopsis>
  22. COMMIT [ WORK | TRANSACTION ]
  23.   </synopsis>
  24.   
  25.   <refsect2 id="R2-SQL-COMMIT-1">
  26.    <refsect2info>
  27.     <date>1998-09-08</date>
  28.    </refsect2info>
  29.    <title>
  30.     Inputs
  31.    </title>
  32.    <para>
  33.     None.
  34.    </para>
  35.   </refsect2>
  36.    
  37.   <refsect2 id="R2-SQL-COMMIT-2">
  38.    <refsect2info>
  39.     <date>1998-09-08</date>
  40.    </refsect2info>
  41.    <title>
  42.     Outputs
  43.    </title>
  44.    <para>
  45.     <variablelist>
  46.      <varlistentry>
  47.       <term><computeroutput>
  48. END
  49.        </computeroutput></term>
  50.       <listitem>
  51.        <para>
  52. Message returned if the transaction is successfully committed.
  53.        </para>
  54.       </listitem>
  55.      </varlistentry>
  56.      <varlistentry>
  57.       <term><computeroutput>
  58. NOTICE EndTransactionBlock and not inprogress/abort state
  59.        </computeroutput></term>
  60.       <listitem>
  61.        <para>
  62. If there is no transaction in progress.
  63.        </para>
  64.       </listitem>
  65.      </varlistentry>
  66.     </variablelist>
  67.    </para>
  68.   </refsect2>
  69.  </refsynopsisdiv>
  70.   
  71.  <refsect1 id="R1-SQL-COMMIT-1">
  72.   <refsect1info>
  73.    <date>1998-09-08</date>
  74.   </refsect1info>
  75.   <title>
  76.    Description
  77.   </title>
  78.   <para>
  79.    <command>COMMIT</command> commits the current transaction. All
  80.    changes made by the transaction become visible to others
  81.    and are guaranteed to be durable if a crash occurs.
  82.   </para>
  83.   
  84.   <refsect2 id="R2-SQL-COMMIT-3">
  85.    <refsect2info>
  86.     <date>1998-09-08</date>
  87.    </refsect2info>
  88.    <title>
  89.     Notes
  90.    </title>
  91.    <para>
  92.     The keywords WORK and TRANSACTION are noise and can be omitted.
  93.    </para>
  94.    <para>
  95.     Use <xref linkend="SQL-ROLLBACK-TITLE" endterm="SQL-ROLLBACK-TITLE">
  96.     to abort a transaction.
  97.    </para>
  98.   </refsect2>
  99.  </refsect1>
  100.  <refsect1 id="R1-SQL-COMMIT-2">
  101.   <title>
  102.    Usage
  103.   </title>
  104.   <para>
  105.    To make all changes permanent:
  106.    <programlisting>
  107. COMMIT WORK;
  108.    </programlisting>
  109.   </para>
  110.  </refsect1>
  111.  
  112.  <refsect1 id="R1-SQL-COMMIT-3">
  113.   <title>
  114.    Compatibility
  115.   </title>
  116.   <para>
  117.   </para>
  118.   
  119.   <refsect2 id="R2-SQL-COMMIT-4">
  120.    <refsect2info>
  121.     <date>1998-09-08</date>
  122.    </refsect2info>
  123.    <title>
  124.     SQL92
  125.    </title>
  126.    <para>
  127.     Full compatibility.
  128.    </para>
  129.   </refsect2>
  130.  </refsect1>
  131. </refentry>
  132. <!-- Keep this comment at the end of the file
  133. Local variables:
  134. mode: sgml
  135. sgml-omittag:nil
  136. sgml-shorttag:t
  137. sgml-minimize-attributes:nil
  138. sgml-always-quote-attributes:t
  139. sgml-indent-step:1
  140. sgml-indent-data:t
  141. sgml-parent-document:nil
  142. sgml-default-dtd-file:"../reference.ced"
  143. sgml-exposed-tags:nil
  144. sgml-local-catalogs:"/usr/lib/sgml/catalog"
  145. sgml-local-ecat-files:nil
  146. End:
  147. -->