Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

UltraLite CHECKPOINT statement

Use this statement to checkpoint the database.

CHECKPOINT

You can use the CHECKPOINT statement as a trigger for a commit flush. A commit flush writes uncommitted transactions to storage.

Alternately, if you are using the embedded SQL API, you can use the ULCheckpoint method, or if you are writing a C++ component application, you can use the Checkpoint method on a connection object. All other APIs must use this statement.

While this statement flushes any pending committed transactions to storage, but does not commit or flush any current transaction.

• Flushing single or grouped transactions
• UltraLite COMMIT_FLUSH connection parameter
• UltraLite embedded SQL: ULCheckpoint function
• UltraLite C++:Checkpoint function