Difference between revisions of "RESET IN"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Disable journaling in a specified workarea | Disable journaling in a specified workarea | ||
| Line 15: | Line 8: | ||
==See Also== | ==See Also== | ||
| − | [[BEGIN TRANSACTION]], [[ | + | [[BEGIN TRANSACTION]], [[COMPLETED()]], [[ISMARKED()]], [[ROLLBACK]], [[ROLLBACK()]], [[SET ROLLBACK]] |
| Line 30: | Line 23: | ||
==Products== | ==Products== | ||
| − | Recital | + | 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
