Difference between revisions of "RESET IN"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
Line 1: | Line 1: | ||
− | |||
− | |||
− | |||
==Class== | ==Class== | ||
Transaction Processing | Transaction Processing | ||
Line 15: | Line 12: | ||
==See Also== | ==See Also== | ||
− | [[BEGIN TRANSACTION]], [[ | + | [[BEGIN TRANSACTION]], [[COMPLETED()]], [[ISMARKED()]], [[ROLLBACK]], [[ROLLBACK()]], [[SET ROLLBACK]] |
Line 33: | Line 30: | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
+ | [[Category:Transaction Processing]] | ||
+ | [[Category:Transaction Processing Commands]] |
Revision as of 14:00, 2 June 2009
Class
Transaction Processing
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