Triggers and isolation levels  Using the lock table command to improve performance

Chapter 20: Transactions: Maintaining Data Consistency and Recovery

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. If your application uses cursors, you must also set the close on endtran option. These options are described in “Using cursors in transactions”.





Copyright © 2005. Sybase Inc. All rights reserved. Using the lock table command to improve performance

View this book as PDF