CHECKPOINT

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

If you are using the embedded SQL API, you can also use the ULCheckpoint method. If you are writing a C++ component application, you can also 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, it does not commit or flush current transactions.

• Flushing single or grouped transactions
• COMMIT statement [UltraLite] [UltraLiteJ]
• UltraLite COMMIT_FLUSH connection parameter
• UltraLite embedded SQL: ULCheckpoint method
• UltraLite C++: Checkpoint method

The following statement performs a checkpoint of the database:

CHECKPOINT;