Transaction processing in CLI overview

Transaction processing shows the typical order of function calls in the transaction processing task of a CLI application.

Not all functions or possible paths are shown.

Figure 1 shows the typical order of function calls in the transaction processing task of a CLI application. Not all functions or possible paths are shown.

Figure 1. Transaction processing
Transaction processing
The transaction processing task contains five steps:
  • Allocating statement handle(s)
  • Preparing and executing SQL statements
  • Processing results
  • Committing or Rolling Back
  • (Optional) Freeing statement handle(s) if the statement is unlikely to be executed again.