Compliance with SQL Standards

To get transactions that comply with SQL standards, you must set the chained and transaction isolation level 3 options at the beginning of every application that changes the mode and isolation level for subsequent transactions.

TIf your application uses cursors, you must also set the close on endtran option.

Related concepts
Use Cursors in Transactions