From 7402eda97c4d1903f4c63b3a05af749b740d5e91 Mon Sep 17 00:00:00 2001 From: "Thomas G. Lockhart" Date: Wed, 13 May 1998 05:34:00 +0000 Subject: First files for reference pages. --- doc/src/sgml/ref/commit.sgml | 179 +++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 179 insertions(+) create mode 100644 doc/src/sgml/ref/commit.sgml (limited to 'doc/src/sgml/ref/commit.sgml') diff --git a/doc/src/sgml/ref/commit.sgml b/doc/src/sgml/ref/commit.sgml new file mode 100644 index 00000000000..63c9dbdc4e1 --- /dev/null +++ b/doc/src/sgml/ref/commit.sgml @@ -0,0 +1,179 @@ + + + + COMMIT + + SQL - Language Statements + + + + COMMIT + + + Commits the current transaction + + + + + + 1998-04-15 + + + COMMIT [ WORK ] + + + + + 1998-04-15 + + + Inputs + + + + + + + + + + + + + None + + + + + + + + + + + + + + + + 1998-04-15 + + + Outputs + + + + + + + + + + + + + END + + + +Message returned if the transaction is successfully committed. + + + + + + NOTICE EndTransactionBlock and not inprogress/abort state + + + + +If there is no transaction in progress. + + + + + + + + + + + + + 1998-04-15 + + + 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-04-15 + + + Notes + + + The keyword WORK is noise and can be omitted. + + + Refer to ROLLBACK statements to abort a transaction. + + + + + + + Usage + + +To make all changes permanent: + + + COMMIT WORK; + + + + + + Compatibility + + + + + + + 1998-04-15 + + + SQL92 + + + Full compatibility. + + + + + + + -- cgit v1.2.3