Difference between revisions of "RESET IN"

From Lianjapedia
Jump to: navigation, search
Line 22: Line 22:
 
[[Category:Commands]]
 
[[Category:Commands]]
 
[[Category:Transaction Processing]]
 
[[Category:Transaction Processing]]
[[Category:Transaction Processing Commands]]
+
[[Category:Databases]]

Revision as of 08:38, 4 February 2013

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

Lianja Server, Lianja