Equinox Online Help - Language Reference - A to Z

Home

TransactGlobalCommit

Applies to
SyntaxTransactGlobalCommit [WaitExpression]
Action[Statement] Commits the transaction log
ScopeUsable anywhere
Notes

If the transaction monitor is running, is sets SysTransactMode to 3 and begins to commit the stored changes to the original files.

While this process continues, transactions applied to files that have not been committed are stored in the transaction list as before.

When the process is complete, SysTransactMode is set to zero. If WaitExpression is supplied as true this command waits until the statement completes. If WaitExpression is false the statements return immediately.

  • Returns SysError = 0 if successfully initiated. Check SysTransactMode to find out the state of the system
  • Returns SysError = 1 if:
    • Currently processing TransactionStart. Try again later, when started.
    • Operator presses Ctrl-Break.
CategoryBackup
See Also TransactGlobalStart, TransactGlobalStats, TransactGlobalTableStats
Example
Switch SysTransactMode
case 0 | Normal Operation
TransactGlobalStart
case 1 | transaction mode starting
Alert "Starting TransactionMode - please wait"
case 2 | transaction mode in force - safe to back up
TransactGlobalCommit
case 3 | commit in progress
Alert "Commit in progress - please wait"
end switch