SQL transactions blocks

The embedded SQL statements INSERT, UPDATE, and DELETE can be used to make changes to the contents of a database table.

If your database has transaction logging, you can use the BEGIN WORK and COMMIT WORK commands to delimit a transaction block, usually consisting of multiple SQL statements. If you do not issue a BEGIN WORK statement to start a transaction, each statement executes within its own transaction. These single-statement transactions do not require either a BEGIN WORK statement or a COMMIT WORK statement. At runtime, the Genero database driver generates the appropriate SQL commands to be used with the target database server.

To eliminate concurrency problems, the execution time of transactions must be as short as possible.