Difference between revisions of "SAVE TRANSACTION"

From Lianjapedia
Jump to: navigation, search
 
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
==Purpose==
 
==Purpose==
 
Identifies a stage within a transaction which can subsequently be used as ROLLBACK point.
 
Identifies a stage within a transaction which can subsequently be used as ROLLBACK point.
 
  
 
==Syntax==
 
==Syntax==
 
SAVE TRANSACTION <savepoint>
 
SAVE TRANSACTION <savepoint>
 
  
 
==See Also==
 
==See Also==
 
[[SQL BEGIN TRANSACTION|BEGIN TRANSACTION]], [[COMMIT]], [[SQL END TRANSACTION|END TRANSACTION]], [[SQL ROLLBACK|ROLLBACK]], [[SAVEPOINT]], [[SET TRANSACTION]], [[TXNISOLATION()]], [[TXNLEVEL()]]
 
[[SQL BEGIN TRANSACTION|BEGIN TRANSACTION]], [[COMMIT]], [[SQL END TRANSACTION|END TRANSACTION]], [[SQL ROLLBACK|ROLLBACK]], [[SAVEPOINT]], [[SET TRANSACTION]], [[TXNISOLATION()]], [[TXNLEVEL()]]
 
  
 
==Description==
 
==Description==
Line 16: Line 13:
 
Issuing the SAVE TRANSACTION <savepoint> statement causes the TXNLEVEL() to increase by 1.  If the transaction is rolled back to the <savepoint> using the ROLLBACK command, the TXNLEVEL will decrease by 1 and  a partial rollback of the transaction will be carried out.  Changes made since the specified <savepoint> was declared are discarded and the transaction continues from the <savepoint>.
 
Issuing the SAVE TRANSACTION <savepoint> statement causes the TXNLEVEL() to increase by 1.  If the transaction is rolled back to the <savepoint> using the ROLLBACK command, the TXNLEVEL will decrease by 1 and  a partial rollback of the transaction will be carried out.  Changes made since the specified <savepoint> was declared are discarded and the transaction continues from the <savepoint>.
  
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.
+
A transaction is a sequence of SQL statements that Lianja 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==
 
==Example==
Line 33: Line 29:
 
// End of program
 
// End of program
 
</code>
 
</code>
 
  
 
==Products==
 
==Products==
Recital Server, Recital
+
Lianja Server, Lianja
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:SQL|SAVE TRANSACTION]]
 
[[Category:SQL|SAVE TRANSACTION]]
 
[[Category:Commands]]
 
[[Category:Commands]]

Latest revision as of 11:08, 11 December 2012

Purpose

Identifies a stage within a transaction which can subsequently be used as ROLLBACK point.

Syntax

SAVE TRANSACTION <savepoint>

See Also

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

Description

The SAVE TRANSACTION statement identifies a stage within a transaction which can subsequently be used as ROLLBACK point. The name of the savepoint is specified in <savepoint>.

Issuing the SAVE TRANSACTION <savepoint> statement causes the TXNLEVEL() to increase by 1. If the transaction is rolled back to the <savepoint> using the ROLLBACK command, the TXNLEVEL will decrease by 1 and a partial rollback of the transaction will be carried out. Changes made since the specified <savepoint> was declared are discarded and the transaction continues from the <savepoint>.

A transaction is a sequence of SQL statements that Lianja 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 parent_and_child
  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())
  SAVE TRANSACTION parent_added
  INSERT INTO accounts (ORD_VALUE) VALUES (30)
  ROLLBACK TRANSACTION parent_added
END TRANSACTION
// End of program

Products

Lianja Server, Lianja