Use this statement to checkpoint the database.

Syntax

CHECKPOINT

Remarks

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.

Side effects

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

See also

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

Example

The following statement performs a checkpoint of the database:

CHECKPOINT;