Difference between revisions of "RESET IN"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) (→Class) |
||
Line 1: | Line 1: | ||
− | |||
− | |||
Revision as of 13:38, 26 October 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 Database Server, Recital Mirage Server, Recital Terminal Developer