Difference between revisions of "COMMIT"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=COMMIT=
 
 
 
==Class==
 
SQL Applications
 
 
 
 
==Purpose==
 
==Purpose==
 
Ends the current transaction, saving changes
 
Ends the current transaction, saving changes
Line 21: Line 14:
 
The COMMIT statement ends the current or specified transaction and any transactions that are nested within it and makes permanent all changes performed in the transaction or transactions.
 
The COMMIT statement ends the current or specified transaction and any transactions that are nested within it and makes permanent all changes performed in the transaction or transactions.
  
TRANSACTION <transaction>
+
====TRANSACTION <transaction>====
 
The optional TRANSACTION <transaction> is used to specify the name of the transaction to be committed.
 
The optional TRANSACTION <transaction> is used to specify the name of the transaction to be committed.
  
WORK
+
====WORK====
 
The optional WORK keyword is included for SQL ANSI 92 compatibility.  COMMIT WORK and COMMIT operate in the same way.
 
The optional WORK keyword is included for SQL ANSI 92 compatibility.  COMMIT WORK and COMMIT operate in the same way.
  
Line 32: Line 25:
 
==Example==
 
==Example==
 
<code lang="recital">
 
<code lang="recital">
// config.db
+
BEGIN TRANSACTION trans1
set sql to recital
+
  INSERT INTO customer;
set sql on
+
    (TITLE, LAST_NAME, FIRST_NAME, INITIAL, STREET,;
// end of config.db
+
    CITY, STATE, ZIP,LIMIT, START_DATE);
 
+
    VALUES;
// Transactions
+
    ('Ms', 'Jones', 'Susan', 'B', '177 High Street','Beverly', 'MA', '01915', 2000, date())
BEGIN TRANSACTION trans1;
+
  INSERT INTO accounts (ORD_VALUE) VALUES (30)
INSERT INTO customer
+
  // Commit the trans1 transaction  
(TITLE, LAST_NAME, FIRST_NAME, INITIAL, STREET,
+
  COMMIT TRANSACTION trans1
CITY, STATE, ZIP,LIMIT, START_DATE)
+
END TRANSACTION
VALUES
+
('Ms', 'Jones', 'Susan', 'B', '177 High Street','Beverly', 'MA', '01915', 2000, date());
+
INSERT INTO accounts (ORD_VALUE) VALUES (30);
+
// Commit the trans1 transaction  
+
COMMIT TRANSACTION trans1;
+
END TRANSACTION;
+
 
// End of program
 
// End of program
 
</code>
 
</code>
Line 53: Line 40:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:SQL]]
 
[[Category:SQL]]
 
[[Category:Commands]]
 
[[Category:Commands]]

Latest revision as of 15:28, 22 December 2009

Purpose

Ends the current transaction, saving changes


Syntax

COMMIT [TRANSACTION <transaction>] [WORK]


See Also

BEGIN TRANSACTION, END TRANSACTION, ROLLBACK, SAVE TRANSACTION, SAVEPOINT, SET TRANSACTION, TXNISOLATION(), TXNLEVEL()


Description

The COMMIT statement ends the current or specified transaction and any transactions that are nested within it and makes permanent all changes performed in the transaction or transactions.

TRANSACTION <transaction>

The optional TRANSACTION <transaction> is used to specify the name of the transaction to be committed.

WORK

The optional WORK keyword is included for SQL ANSI 92 compatibility. COMMIT WORK and COMMIT operate in the same way.

A transaction is a sequence of SQL statements that Recital treats as a single unit. A transaction begins with the first executable SQL statement after a BEGIN TRANSACTION. A transaction ends with a COMMIT, ROLLBACK or END TRANSACTION.


Example

BEGIN TRANSACTION trans1
  INSERT INTO customer;
    (TITLE, LAST_NAME, FIRST_NAME, INITIAL, STREET,;
    CITY, STATE, ZIP,LIMIT, START_DATE);
    VALUES;
    ('Ms', 'Jones', 'Susan', 'B', '177 High Street','Beverly', 'MA', '01915', 2000, date())
  INSERT INTO accounts (ORD_VALUE) VALUES (30)
  // Commit the trans1 transaction 
  COMMIT TRANSACTION trans1
END TRANSACTION
// End of program


Products

Recital Server, Recital