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.

© Copyright 2000-2020 Micro Focus or one of its affiliates.