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.