From 1ac838edba409abe87649c6820a9ee492cb1a1c5 Mon Sep 17 00:00:00 2001 From: "Thomas G. Lockhart" Date: Mon, 14 Jun 1999 07:37:05 +0000 Subject: Minor updates for release. Split reference pages for CREATE TABLE AS and SELECT INTO to allow psgml (the emacs parser) to handle parsing. --- doc/src/sgml/ref/commit.sgml | 191 ++++++++++++++++++++++--------------------- 1 file changed, 96 insertions(+), 95 deletions(-) (limited to 'doc/src/sgml/ref/commit.sgml') diff --git a/doc/src/sgml/ref/commit.sgml b/doc/src/sgml/ref/commit.sgml index 55c6212dd5c..3dc8984f9dc 100644 --- a/doc/src/sgml/ref/commit.sgml +++ b/doc/src/sgml/ref/commit.sgml @@ -1,141 +1,142 @@ - - - + + + COMMIT - - SQL - Language Statements - - - + + SQL - Language Statements + + + COMMIT - - + + Commits the current transaction - + - - - 1998-09-08 - - + + + 1998-09-08 + + COMMIT [ WORK | TRANSACTION ] - + - - - 1998-09-08 - - + <refsect2 id="R2-SQL-COMMIT-1"> + <refsect2info> + <date>1998-09-08</date> + </refsect2info> + <title> Inputs - - + + None - + - - - 1998-09-08 - - + <refsect2 id="R2-SQL-COMMIT-2"> + <refsect2info> + <date>1998-09-08</date> + </refsect2info> + <title> Outputs - - + + - - - - END - - - -Message returned if the transaction is successfully committed. - - - - - - NOTICE EndTransactionBlock and not inprogress/abort state - - - + + + + END + + + + Message returned if the transaction is successfully committed. + + + + + + NOTICE EndTransactionBlock and not inprogress/abort state + + + If there is no transaction in progress. - + - - + + - - - 1998-09-08 - - + <refsect1 id="R1-SQL-COMMIT-1"> + <refsect1info> + <date>1998-09-08</date> + </refsect1info> + <title> Description - - + + 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. - + - - - 1998-09-08 - - + <refsect2 id="R2-SQL-COMMIT-3"> + <refsect2info> + <date>1998-09-08</date> + </refsect2info> + <title> Notes - - + + The keywords WORK and TRANSACTION are noise and can be omitted. - + + - Use the ROLLBACK statement to abort a transaction. + Use + to abort a transaction. - + - - + <refsect1 id="R1-SQL-COMMIT-2"> + <title> Usage - - -To make all changes permanent: - - + + + To make all changes permanent: + COMMIT WORK; - - + + + - - + <refsect1 id="R1-SQL-COMMIT-3"> + <title> Compatibility - - - + + + - - - 1998-09-08 - - + <refsect2 id="R2-SQL-COMMIT-4"> + <refsect2info> + <date>1998-09-08</date> + </refsect2info> + <title> SQL92 - - + + Full compatibility. - + - - +