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.

• Flush single or grouped transactions
• COMMIT statement [UltraLite]
• UltraLite COMMIT_FLUSH connection parameter
• ULCheckpoint method [UltraLite Embedded SQL]
• ULConnection.Checkpoint method [UltraLite C++]

The following statement performs a checkpoint of the database:

CHECKPOINT;