Difference between revisions of "RESET IN"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=RESET IN=
 
 
 
==Class==
 
Transaction Processing
 
 
 
 
==Purpose==
 
==Purpose==
 
Disable journaling in a specified workarea
 
Disable journaling in a specified workarea
Line 15: Line 8:
  
 
==See Also==
 
==See Also==
[[BEGIN TRANSACTION]], [[ROLLBACK]], [[SET ROLLBACK]], [[COMPLETED()]], [[ISMARKED()]], [[ROLLBACK()]]
+
[[BEGIN TRANSACTION]], [[COMPLETED()]], [[ISMARKED()]], [[ROLLBACK]], [[ROLLBACK()]], [[SET ROLLBACK]]
  
  
Line 30: Line 23:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Commands]]
 
[[Category:Commands]]
 +
[[Category:Transaction Processing]]
 +
[[Category:Transaction Processing Commands]]

Latest revision as of 16:18, 12 November 2009

Purpose

Disable journaling in a specified workarea


Syntax

RESET IN <workarea | alias>


See Also

BEGIN TRANSACTION, COMPLETED(), ISMARKED(), ROLLBACK, ROLLBACK(), SET ROLLBACK


Description

The RESET IN command is used to disable Before Image Journaling (BIJ) in the specified workarea. When BEGIN TRANSACTION is issued, all currently open tables and all tables opened between BEGIN and END TRANSACTION will have BIJ invoked automatically. If BIJ is not required on a particular table, then the RESET IN command should be issued for the relevant workarea.


Example

// Clear BIJ in workarea suppliers
reset in suppliers


Products

Recital Server, Recital