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

数据库系统

开发平台:

Unix_Linux

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