InstantSQL Transaction

Transaction
Flowchart

< > Connection Statements Query Statements Advanced Statements Transaction Example Table of Contents

This flow chart shows the typical pattern for a simple select and update transaction using InstantSQL. Error handling is not shown in order to simplify the flow chart. An application should check for errors following each InstantSQL statement as shown in the status inquiry flow charts.

The flowchart shows using a cursor concurrency of lock for the SELECT statement when it is prepared. This will ensure that the data source locks the selected records so that they can be updated. However, some data sources do not honor this request, for example, DB2, unless the FOR UPDATE clause is specified in the SELECT statement.